Receive data from a "Power BI Data Flow" in to Flow (Power Automate)

(1) Share

Report

Posted on by ffritz

158

Is there a possibility to receive data from a "Power BI Data Flow" in to Flow (Power Automate)?

My Use Case is to enter coming from a SAP BW and other sources via "Power BI Data Flow" in to a SharePoint List.

Currently the Result of the Query is Download Manually from Power BI and copied in to SharePoint.

I have updated Excel Tables in to SharePoint so far but I did not see any option utilising "Power BI Data Flow's" so far.

I have seen that Power Query Data Flows can be used in Azure directly, but here I would need help if that would be an option.

Thanks

Fritz

Categories:

Using connectors

I have the same question (0)

All responses (9)

Answers (0)

v-alzhan-msft on at

Like (0)

Report

Hi @ffritz ,

Could you please explain more details about the Power BI Data Flow that you mentioned?

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
ffritz 158 on at

Like (0)

Report

here the description of Power BI Data Flows
https://docs.microsoft.com/en-us/power-bi/service-dataflows-overview

here the description how the results of the Data Flows's are stored in the Azure Data lake
https://docs.microsoft.com/en-us/power-bi/service-dataflows-azure-data-lake-integration

In general the PBI Data Flow is like a Power Query that runs in the cloud and stores the result there for PBI Reports to use.

Rgds
Fritz

Was this reply helpful? Yes No

ffritz

158 on at

Like (0)

Report

Maybe this helps as well

here an example how to connect to a Power BI Data Flow Source in M-Code (e.g. from Power BI Desktop)

Source = PowerBI.Dataflows(null),
#"ad33b348-02a5-4182-baa6-48230ce95ce5" = Source{[workspaceId="ad33b348-02a5-4182-baa6-48230ce95ce5"]}[Data],
#"fec414e9-a4e4-4e3f-a37d-3296f4f19117" = #"ad33b348-02a5-4182-baa6-48230ce95ce5"{[dataflowId="fec414e9-a4e4-4e3f-a37d-3296f4f19117"]}[Data],
ResponsibilityMatrix1 = #"fec414e9-a4e4-4e3f-a37d-3296f4f19117"{[entity="ResponsibilityMatrix"]}[Data],

Was this reply helpful? Yes No

xsg13 30 on at

Like (0)

Report

@ffritz
Did you have any luck in finding a way to do this?

Was this reply helpful? Yes No
ffritz 158 on at

Like (0)

Report

No, I did not have time yet (since it's currently not that high priority).

What I planned to try next is, to create an Azure Storage Account, connect the Workspace (with the DataFlow) to it.
Which then gives me a CSV File with the result of the DataFlow on the Azure Storage Account.
This I then would try to access from Flow.

But I do not know yet if it will work, and I wont have time to try it for some time.

Was this reply helpful? Yes No
ffritz 158 on at

Like (0)

Report

No, I did not have time yet (since it's currently not that high priority).

What I planned to try next is, to create an Azure Storage Account, connect the Workspace (with the DataFlow) to it.
Which then gives me a CSV File with the result of the DataFlow on the Azure Storage Account.
This I then would try to access from Flow.

But I do not know yet if it will work, and I wont have time to try it for some time.

Was this reply helpful? Yes No
xsg13 30 on at

Like (0)

Report

One workaround is to have an intermediary Power BI dataset. If you have your Dataflow consumed into the PBI Dataset, you can pull the data into the Power Automate from there with the PBI connector.

You will need to then create another Power Automate to trigger a Power BI Dataset refresh at the successful completion of a Dataflow Refresh so the data stays up to date.

This works, but it is not convenient.

Was this reply helpful? Yes No
Jöse 4 on at

Like (0)

Report

Hi @xsg13

Your solutions sound exactly how i need to solve my issue with getting data from PowerBI, but do you have an example of how you can share. I have difficulties in the step from dataflow refresh and then triggering a dataset refresh - shouldn't there be a delay from the start of the dataflow refresh to the dataset refresh, since you want your dataset to be refreshed based upon the newly refreshed dataflow data?

next how do you get your data extracted from the PowerBI dataset?

Was this reply helpful? Yes No
Jöse 4 on at

Like (0)

Report

Was this reply helpful? Yes No