The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm currently using PowerBI cmdlets and REST API to export a number of Paginated reports to PDF and Excel.
As part of this it would be useful if there was an API to list the expected parameters for a Paginated Report. Does this already exist?
Solved! Go to Solution.
Hi @millwardt ,
According to your requirement description, you want to list the expected parameters for a Paginated Report through Power BI rest API, according to my research and search, you can conveniently disclose what you specifically want to get the expected parameters parameters here from the documentation can see is that you can use this API to get a list of data sources for the specified paginated report (RDL) from the specified workspace.
Reports - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
You can use this API to get a list of reports for a given workspace, but note that since paged reports (RDLs) do not have datasets, the dataset ID value of the paged report in the API response will not be displayed.
Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution doesn't solve the problem.
This doesn't give the paginated report parameters which we asked in the question. So that user can pass it to the export report
Were you ever able to find a solution here?
I'm afraid not
Hi @millwardt ,
According to your requirement description, you want to list the expected parameters for a Paginated Report through Power BI rest API, according to my research and search, you can conveniently disclose what you specifically want to get the expected parameters parameters here from the documentation can see is that you can use this API to get a list of data sources for the specified paginated report (RDL) from the specified workspace.
Reports - Get Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
You can use this API to get a list of reports for a given workspace, but note that since paged reports (RDLs) do not have datasets, the dataset ID value of the paged report in the API response will not be displayed.
Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.