Connect Power Automate data to power BI

[PC20]

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 be approx 10 visualizations created on this data.
Is there a way to do this, without storing Power Automate output somewhere and using that as a data source in Power BI?

[Ahmed-Elfeel]

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]

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.

[Ahmed-Elfeel]

I didnt notice it is no longer, I Searched to get the help him and thanks for noticing it☺️❤️:

• Real-time streaming in Power BI
• Load data in a Power BI streaming dataset and build a dataflows monitoring report with Power BI 

[BugmanJ]

@PC20  Yes, in power automate search for "Add rows to dataset". This will output rows to the dataset, but note that your data columns/format must match the dataset perfectly or it will fail. Also, never refresh the dataset or you will lose the data.

Storing it would be easier mind!