Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Solved! Go to 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.
Best Regards
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.
Best Regards
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |