Connect Power Automate data to power BI

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!

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 ☺️❤️