Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Downloading data from a report outside the service

Can I add a button that will load data from a report to a local computer. The report will be placed outside of the Power BI service. The file should save in Excel format

Frequent Visitor

The paginated report functions are only available to users with a premium subscription.
My reports will be available to the public. So there will be no option to use the paginated reports feature.


Is there another way to download data from a report published outside of the Power BI service to Excel to the users' local device.

Responsive Resident
Responsive Resident

my suggestion is to deploy a paginated report in the same workspace with the table you want to export and use paginated report export built-in functionalities.

create a button in power bi report that calls the paginated uri asking for export in xlsx format.

for example:<wrksid>/rdlreports/>reportid>?Format=XLSX


download will be automatic

Frequent Visitor

It will be a public report, visible to everyone on the client's website. The data will be used by students.

The client wants to give the option to download the presented data to a file.

Responsive Resident
Responsive Resident

maybe a paginated report run directly in power bi report builder can help you.

anyway I can't imagine the scenario you're trying to address.



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors