Use Power Automate to export a Power BI report table dataset to excel on sharepoint

Question

hello&nbsp;We want to automate a recurring process where we need to work with data that is generated from a refreshed Power BI report.We are using Power Automate to refresh the report.Is it possible also to export a Power BI report table dataset to excel on sharepoint via Power Automate?&nbsp;thanksMaarten

anonymous · Answer

Hi&nbsp;mburssens&nbsp;,&nbsp;I tried to find some related documents about exporting data to excel automatically, hopefully works for you.https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/.https://blog.crossjoin.co.uk/2018/09/26/using-power-query-and-microsoft-flow-to-automate-the-creation-of-csv-files/.https://powerusers.microsoft.com/t5/Building-Flows/How-to-automate-Export-to-Excel-for-a-SharePoint-list-using-flow/td-p/278477.https://docs.microsoft.com/en-us/power-automate/run-scheduled-tasks.&nbsp;Best Regards,JayCommunity Support Team _ Jay WangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Use Power Automate to export a Power BI report table dataset to excel on sharepoint

1 Reply

Related content

Refresh Power BI Dataset using Power Automate

Dataset refresh via Power Automate Flow - clarifications

Upload files from Sharepoint using Power Automate

Requirements to run a query against a dataset on power automate

Automated refreshes