Our users require the option to download what they are seeing in a Power BI table into Excel. Rather than allowing them to use the Export Data into CSV option, we would prefer to give them a fully formatted Excel download.
Paginated Reports using URL parameters, as described in this Guy In A Cube video: https://youtu.be/KYfhclGrI48, appears to be great for this, but we are struggling to get it to work when we have many values in the slicer.
The issue is that whilst we can pass one or many selected values in the URL, there appears to be a limit and beyond this limit the URL will fail. Please see attached examples:
Paginated Power BI Report.pbix. Mock up report containing one slicer, one table and an Excel download button. Measure Base Export URL creates the URL string to be passed, by concatenating all of the selected values into a URL, which includes the baseURL of the paginated report (pre uploaded into the service)
Paginated Power BI Report.pbix (154.6 KB)
RDL file Paginated Report Test containing a simple table. Parameter ‘Sites’ receives the list of indexes (Store numbers) from the Power BI Report.
Paginated Report Test.rdl (40.4 KB)
How to use:
1, Upload the Paginated Report .rdl file into a Workspace and copy and paste its url from within the service.
2, Open the Power BI report in Desktop and paste the URL into variable __baseURL1 in measure Base Export URL.
3, Select a few sites from the slicer and Ctrl-Click the Excel download button.
4, The paginated report should then open, run and an Excel download will occur.
However if you use ‘Select All’ in the Slicer, the report will fail with the error:
This app.powerbi.com page can’t be found.
If you select all values and then uncheck the last 4 (so that Tesco Teeside is the last selected value), then the report will work. However include Tesco Tetbury and it fails.
I am therefore wanting to find a solution to effectively not pass every value to be checked, but instead being able to pass a ‘Select All’ value.
Any thoughts on how to get around this very much appreciated!