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

[adam22]

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-_Toc8747...

(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.

[Anonymous · Accepted solution]

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 "(f904...

Best Regards

[adam22]

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.