Automatically downloading the Report Table in PowerBI report in Excel

[vector784]

Hi,

I am trying to find a way to automatically download or scheduled the "Export to Excel" of PowerBI repor table, if possible in any way, because right now it takes lot of manual effort to download it.

Export Data -> Export to Excel

Thanks, Is it something which is possible?

[vector784]

Hi,

Thanks for your response,

Will this work with users who have viewer access only(For report only). 
Note : User doesn't have access to Workspace and Dataset

[v-binbinyu-msft]

Hi @vector784 ,

So far, to my knowledge, there is no way to export Power BI Table visual data automatically.

But there is a workaround for you:

1. create a report with Table visual

2. export the report to file with Power Automate

For more details, you can read related document: Export and email a report with Power Automate - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.