Skip to main content

Power BI

New

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

Vote (1) Share
Herr B's profile image

Herr B on 03 Jul 2024 14:08:38

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

Comments (2)
Herr B's profile image Profile Picture

Herr B on 03 Jul 2024 22:04:45

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

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")

Herr B's profile image Profile Picture

Herr B on 03 Jul 2024 22:00:59

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

Problem exists since introduction of paginated visuals (as an example),Also described here with images and nice colors: