AUTOMATE EXPORT TO EXCEL FROM POWER BI REPORT

[vijay273162]

Hi Guys,

Is there a FLOW to automate export of Excel from POWER BI report. It needs to be a scheduled flow.

Note :

I don't need POWER BI button (instant flow)

Output needs to be in .xlsx (or) .csv

No need any third party application for this work.

Please share me the MS Flow design to setup.

[vijay273162]

Is there a way to create Custom Connector to use POWER BI REST API - for creating Export to CSV from POWER BI automatically.

Microsoft till date, keep this feature no incorporated (INTENSIONALLY)

Since I see couple of 3rd party apps, using this drwaback as opportunity to build the Software to do this report scheduling task.

[v-easonf-msft · Accepted solution]

Hi, @vijay273162 

You can consider using R script to export data or download data out of Power BI.

But it requires you to install a personal gateway and configure schedule refresh.

For more details, please refer to this tutorial.

YouTube: Schedule data downloads / exports in Power BI 

Best Regards,
Community Support Team _ Eason

[vijay273162]

Yes, I checked the above post, I need to export it in .CSV or .xlsx format,

which is not supported in above MS FLOW design 

[ribisht17]

Hello,

Have you checked this Solved: Export PowerBI Data To Excel Via Power Automate - Power Platform Community (microsoft.com) ?

Regards,

Ritesh