Power BI REST API: Update getReportsInGroup/getReportInGroup/etc to get all the information you need to create a valid embedding token

[bjoern_behrens]

Creating an embed token for Power BI today is a complex task, as not only a report may have to be embedded, but the report may use datasets from different workspaces, DataMarts, DataFlows or may embed paginated visuals etc.

Unfortunately, it is not possible to get all required information to embed a certain report by an API.

An example is embedding a Power BI report, which contains a paginated visual (technically that is a paginated report (RDL) shown within a Power Bi report (PBIX)): https://learn.microsoft.com/en-us/rest/api/power-bi/embed-token/generate-token#example-of-generating-an-embed-token-for-a-power-bi-report-with-a-paginated-visual.-the-paginated-report-id-('...4850')-of-the-paginated-visual-must-be-included-in-the-'reports'-section-of-the-request.

This requires the information about:

• DataSet ID
• Power BI Report ID
• Paginated Report ID

Provided by the Power BI REST APIs will be:

• DataSet ID
• Power BI Report ID
• Paginated Report ID

While there is a REST API to get all reports in a workspace (or organisation), including the paginated reports itself, there is no REST API providing the relation between Power BI report and Paginated report.

Please enhance the report APIs to provide all required information to create also a complex, multi-access token as described in the GenerateToken method (see examples: https://learn.microsoft.com/en-us/rest/api/power-bi/embed-token/generate-token#examples)

Regards,

HerrB@S-Com

[bjoern_behrens]

Problem exists since introduction of paginated visuals (as an example),

Also described here with images and nice colors:

[bjoern_behrens]

As links does not seem to be possible in comments:

2021: See MS Fabric Community posting 2215388 ("Get Report ID of RDL Report that is embedded inside PowerBI")

2022: Same user tried it again: See MS Fabric Community posting 2426436 ("How To Obtain Report ID of RDL Paginated Report that's embedded")