topic Get Report ID of RDL Report that is embedded inside PowerBI report (Paginated report inside PowerBI) in Developer

Get Report ID of RDL Report that is embedded inside PowerBI report (Paginated report inside PowerBI)

adam22 — Fri, 26 Nov 2021 16:26:40 GMT

Hi All.

How Do we get the ReportID of a Paginated Report from a Power BI Report ID?

Explanation:

With the new(ish) PowerBI RDL/Paginated report visual, you can embed a power bi paginated report inside a PowerBI report.

Now, in NOVEMBER 2021 - we can use this feature in App Owns Data/Customer Owns Data mode of embedding.

https://powerbi.microsoft.com/en-gb/blog/power-bi-november-2021-feature-summary/#post-17912-_Toc87473967 (

(Support embedding a Power BI report that contains a paginated report visual)

Great... except. we need to know the ReportID of the RDL Report, but, as a software application, we only have the POWER BI Report ID.

Existing GetReport API Doesn't give the 'linked RDL Reports' https://docs.microsoft.com/en-us/rest/api/power-bi/reports/get-report

{ "datasetId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229", "id": "5b218778-e7a5-4d73-8187-f10824047715", "name": "SalesMarketing", "webUrl": "https://app.powerbi.com//reports/5b218778-e7a5-4d73-8187-f10824047715", "embedUrl": "https://app.powerbi.com/reportEmbed?reportId=5b218778-e7a5-4d73-8187-f10824047715" }

So, Where/How Do we get the ID of an RDL file from a Report?

Please help.

One option is to get all the RDL reports in the whole workspace that the Power BI Report resides, but in our app, we only give people very specific access, not whole workspaces, so this doesn't hold for security reasons.

Re: Get Report ID of RDL Report that is embedded inside PowerBI report (Paginated report inside Powe

Anonymous — Wed, 01 Dec 2021 05:27:03 GMT

Hi @adam22 ,

As mentioned in the blog, the service principal must have access to both reports (paginated and Power BI). Master user is not supported. You can use the following API call to get the paginated report ID for PowerBI reports with a paginated visual. You can get more details in the following link.

Generate an EmbedToken for a Power BI report with a paginated visual. The paginated Report ID "(f904e89a-7ebe-4aa0-8647-e409063b4850)" of the paginated visual has to be included in the report IDs section.

Best Regards

Re: Get Report ID of RDL Report that is embedded inside PowerBI report (Paginated report inside Powe

adam22 — Wed, 22 Dec 2021 08:25:50 GMT

Hi @Yingyingr thank you for the reply, apologies for my late reply back.

Yes, I understand the following:

1. we can just pass in the ID of the extra report in the reports collection.

2. we need to have access to both reports

3. we use service principal

So that's all good, you and I are on the same page there.

However, when I only have the ID of the PowerBI Report, how do I determine the ID(s) of the Paginated reports?

There is no API call for this, so the whole thing doesn't work 😞

Thanks for your help.