I am using Power Bi - Reporting Server (RS) version in office.
I want to give a button on my report to export the data in MS - Excel.
After some research i found out it can be done through power Automate, however that option is not support in Power bi RS Version.
Any Alternate ways / suggestion how can i achieve it.
It’s a general question, hence not updating PBIX file.
Hi there, I just typed your question into ChatGPT 3.5 and this what came up
If you’re using Power BI Report Server (RS) and you want to provide a button on your report to export the data to MS Excel, you have a few alternative options you can consider:
Export to Excel from Power BI Service: If your organization has access to the Power BI service (Power BI Premium or Power BI Pro licenses), you can publish your report to the Power BI service and then use the built-in “Export to Excel” feature available in the Power BI service. This allows users to interact with the report and export data to Excel directly from the service.
Custom Export using URL Parameters: Power BI Report Server supports URL parameters, which can be used to customize report behavior. You can create a custom button or link in your report that generates a URL with appropriate parameters to trigger the export of data to Excel. This URL can include parameters like “rs:Format=EXCELOPENXML” to specify the export format as Excel. However, note that this approach will open a new browser window to download the Excel file directly from the server.
Custom Export using Power Automate (formerly Microsoft Flow): While you mentioned that Power Automate is not supported in Power BI Report Server, it’s essential to mention that the capabilities of Power BI Report Server might have evolved since my last update in September 2021. It’s worth checking the latest documentation or official Microsoft sources to see if Power Automate integration is now available for Power BI Report Server.
Scheduled Data Refresh to Shared Network Location: Another option is to configure scheduled data refresh for your Power BI Report Server report. During the scheduled refresh, you can set up the report to save a copy of the dataset in a shared network location in Excel format. Users can then access this shared location to download the updated Excel file.
Export Data from Visualizations: Depending on the complexity of your report and data, you can allow users to select and copy data from visualizations in the report and then paste it into Excel manually.
Remember that some of these options might have specific security and permission considerations, so ensure that the appropriate access levels are set up for data export functionalities. Additionally, Power BI Report Server updates may introduce new features, so always refer to official Microsoft resources or release notes for the latest information on available features and updates for Power BI Report Server.
Hello @EnanBahadur, and I have a question. What is your fallback plan if you are unable to implement a Button as you describe? Would you share which available features ‘just don’t quite fit what I want to do’.
