topic Re: Power BI API Get Paginated Datasource in Developer

Power BI API Get Paginated Datasource

srduval — Fri, 11 Aug 2023 16:11:10 GMT

I'm trying to find the power bi API that would allow me to see the dataset details of a paginated report. Basically i'm trying to use the API to look into the paginated reports (and pbix if that's possible) and log the SQL object refrerenced along with the report name, to form an index of sorts to help navigate changes.

Re: Power BI API Get Paginated Datasource

AmosHersch — Sat, 12 Aug 2023 08:44:02 GMT

I believe you should try this API for a list of paginated report data sources

Reports - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Re: Power BI API Get Paginated Datasource

Martin_D — Sat, 12 Aug 2023 19:03:30 GMT

Indeed, the get datasources REST API works for normal and rdl (paginated) reports as well. I've tried. In PowerShell, use Invoke-PowerBIRestMethod. If the data source of your paginated report is a dataset, and you want to get the underlying SQL-Server, you need a subsequent call of Datasets - Get Datasources - REST API.

Re: Power BI API Get Paginated Datasource

srduval — Mon, 14 Aug 2023 13:24:06 GMT

Am i missing something, when I review the API on the website as well as running it myself, this API only gets me to the database level, looking to take it down the next level to say it's running the stored procedure dbo.xyz

Re: Power BI API Get Paginated Datasource

srduval — Tue, 15 Aug 2023 16:56:02 GMT

The export Report API appears to allow me to back into the RDL/XML code and tease the command text out of the source code. Doesn't work for pbix files that have been compressed however, so I'll have to keep digging for those