Forum Discussion
PowerBI Paginated Reports - URL Parameters
Hi
Is it possible to pass parameters into a PowerBI Paginated report via the URL?
I'm looking to direct users to a Paginated Report from an Interactive report, passing across details such as account number, time period etc... to stop them having to re-select.
Since this forum is focused on the on-prem Power BI Report Server product I had assumed that you were asking about that (which is what the links I posted relate to).
As far as I am aware this is not yet supported on the Power BI service, but I have my fingers crossed that this will be added soon as it's a fairly important feature that a lot of people would use.
10 Replies
Yes you can, the wat to do this is using the following technique https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url?view=sql-server-2017
There are a lot of other things you can control with url parameters including things like the render format so that you can link directly to a PDF or some other file format see: https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-2017
Hi
Thanks for your reply. I did try this with a paginated report but kept getting the parameter prompt coming up empty.
This is the syntax I've used
where my parameter is called param_PHC
This is now supported and available - https://powerbi.microsoft.com/en-us/blog/url-parameters-for-paginated-reports-are-now-available/
Hi chrisfin I saw this a few days ago and started plating around, but I have another question now. I have to have an account with permissions to see the report so I need to manually log into PowerBI to actually see the report and download the pdf. I am trying to execute the pdf from another program but I'm not sure if this is possible (if I haven't logged in earlier). I can't find anything related to authentication parameters or request body for paginated reports with parameters. Can you shed some light on this please? Thanks!
You'll still need to login currently - the Power BI embedded team is actively working on support for paginated reports for PaaS scenarios, including more robust public API support and would support this parameter pattern as part of that, so at that time there should be a way to handle scenarios like you describe.
