Forum Discussion

PC20's avatar
PC20
Frequent Visitor
3 years ago

Connect Power Automate data to power BI

I have a Power Automate flow to read the Sharepoint data, do some transformations. I want to read this flow's output data directly (in csv format) from power automate to Power BI, where there will b...
Need Help
Ahmed-Elfeel's avatar
Ahmed-Elfeel
Icon for Super User rankSuper User
9 months ago

Hi PC20,

While there is no direct method to stream a CSV from Power Automate to Power BI without any form of storage, So you can architect solutions that minimize manual steps and avoid traditional file management.

 

The Approach: Called Dataset Endpoint

The idea here is to treat your Power BI dataset as a data endpoint for Power Automate to write to directly.

So Instead of Power BI pulling data, have Power Automate push the transformed data into a predefined Power BI dataset which then serves as the direct source for your 10 visualizations (I hope you understand)

 

How to Implement it?

  • In Power BI Desktop use Power Query to define the exact schema (table and columns) for your transformed data and publish an empty dataset to the Power BI Service
  • Use the Power Automate connector for Power BI. In your flow after transforming the SharePoint data add the Add rows to a dataset action (This action pushes your data row by row into the Power BI dataset table)

And that is it If you have any questions I am here ☺️❤️

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
9 months ago

AI generated. Option 2 is no longer possible post Oct 24 and Dataverse is still storing data before it gets pushed into the dataset.

Option 1 as originally suggested using the "add rows to dataset" is the only path.