You’re offline. This is a read only version of the page.
Announcements
Hello,
I'm wondering if someone can provide some advice. I have created a couple of flows that do a multitude of things, but to dumb things down, they essentially fetch data using HTTP. This data is fetched:
Currently, these tables are saved into my OneDrive as CSV files. The flows run every night so the CSV files are replaced daily, refreshing the data so it's as accurate as possible.
I then have a Power BI dataflow that fetches the contents of these CSV files and stores them, so I can create Power BI reports.
I feel like saving the files to CSVs in my OneDrive is an unnecessary step. Is there a recommended, or better way, to transfer data from a Power Automate flow into a Power BI dataflow? I thought about using a SQL database instead of OneDrive, but that would mean the flow takes even longer to execute.
Any ideas are much appreciated.
Thank you
Using Dataverse tables and Dataflows is helpful because it doesn't have to replace all of the data in the table, it would just update things that changed.
I have only used Dataflows with CSV files, but there are a lot of other connection options in a Dataflow. The dataflow could be scheduled, or you could trigger the dataflow with a power automate flow.
I can only use Dataverse for Teams which is like a limited version.
Share
Report
All responses (
Answers (
6,519
