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
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?
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.
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.
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.
@ffritz
Did you have any luck in finding a way to do this?
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], |
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
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.