Power Platform Community Forum Thread Details

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:

Azure AD/Entra Users (using MS Graph)
Azure AD/Entra License Assignments (using MS Graph)
Azure AD/Entra Licenses (using MS Graph)
Adobe Users (using the Adobe API)
Adobe Groups (using the Adobe API)

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

Categories:

General topics