Is there a way to dump a Power BI dataset into a file using Power Automate?

[WebPortal]

Hi all,

I have a Power BI dataset that retrieves data from a SQL Server database every day, but it doesn't keep the historical data.

Is there a way to dump the dataset into a file using Power Automate? Once per day?

This would solve my problem.

Thank You.

[v-jefferni · Accepted solution]

Hi @WebPortal ,

With Power Automate, the answer is no. But I found a blog in Power BI community:

Schedule Automated Data Exports from Power BI usin... - Microsoft Power BI Community

Hope this helps.

Best regards,

[WebPortal]

@v-jefferni 

Thanks for helping. It's hard to believe this isn't possible to do with Power Automate, isn't it a much requested feature?

With R or Python, I can handle, I was just trying to avoid data gateways.

Thank you so much!