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
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.
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:
https://app.powerbi.com/groups/<wrksid>/rdlreports/>reportid>?Format=XLSX
download will be automatic
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.
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.