Automate Exporting of Data from PBI Visual to Excel

[Anonymous]

Hello,

I was just wondering if it is possible to automate the exporting of data from a particular visual to Excel? Maybe through Power Automate or through a script?

Would appreciate any help 🙂

[Mariusz · Accepted solution]

Hi @Anonymous 

You can create an Excel file that is live  conected to the dataset in the Power BI service as per below and create a pivot that conteins the filds and measures form that specific visual 

with https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

or you can use third party software like:

https://powerbitiles.com/?app=PBIRobots 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous · Accepted solution]

Hi @Anonymous,

You can take a look at the following blog about use power bi automate with rest API to export data from your report data:

Category Archives: Power BI API 

Regards,

Xiaoxin Sheng

[Mariusz · Accepted solution]

Hi @Anonymous 

You can create an Excel file that is live  conected to the dataset in the Power BI service as per below and create a pivot that conteins the filds and measures form that specific visual 

with https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

or you can use third party software like:

https://powerbitiles.com/?app=PBIRobots 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thank you @Mariusz !

I will confirm if my client has Pro license for the Analyze Excel feature, but in any case, do you have other options for free accounts?