Forum Discussion
Exporting Paginated Report to excel, pdf, and json using Power BI API, with parameters passed
Hi Cherubelk
You can try troubleshooting the issue with--
Verify Parameter Names:
-
Open your paginated report in Power BI Report Builder.
-
Navigate to the Parameters pane.
-
Confirm the exact names of the parameters. Note that parameter names are case-sensitive and may include underscores or other characters.
Power BI -Export Paginated Report.
2.You can also Test with Known Values:Before deploying the solution, test the API call with known parameter values to ensure that the report exports as expected.
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
-
-
Hi Cherubelk
You can try troubleshooting the issue with-
-
Verify Parameter Names:
-
Open your paginated report in Power BI Report Builder.
-
Navigate to the Parameters pane.
-
Confirm the exact names of the parameters. Note that parameter names are case-sensitive and may include underscores or other characters.
Power BI -Export Paginated Report.
2.You can also Test with Known Values:Before deploying the solution, test the API call with known parameter values to ensure that the report exports as expected.
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
-
Thank you, I was able to export the report prior to this post but it very similar to how I was able to export.
At first I had created a Paginated Report in Power BI Service, this is the report I was using to test this export. The report created in Power BI Service was able to download and export when it had no parameters. After adding parameters to that same report and trying to export it I was unable to.
Given another Paginated Report that was developed with Power BI Report Builder, with defined parameters, I was able to export the report.
Maybe a bug, but parameters are not recognized by the Power BI REST API given that the pagniated report and parameters were created using Power BI Service and not Power BI Report Builder.