topic Embedded paginated report in Developer

Embedded paginated report

Rohan-25 — Fri, 03 Mar 2023 07:39:50 GMT

I am trying to embedded paginated report inside Bi report
for that i am using REST API and service principle account to get all required data like embedded url, embedded token
getting all data but when redering in fronend or in sandbox it's throwing error(image attached)

Re: Embedded paginated report

AmosHersch — Sun, 05 Mar 2023 08:10:59 GMT

So do you have a Power BI report with a paginated report visual inside it?

How did you generate the embed token for the report? Such errors usually mean that something is wrong with the embed token.

Re: Embedded paginated report

Rohan-25 — Mon, 06 Mar 2023 07:48:18 GMT

Yes, In the first image(sample application) I have Power BI report with a paginated report visual inside
and in second image(sandbox) i have paginated report
and to generate embedded token i am following generating an embed token for a Power BI report with a paginated visual

Re: Embedded paginated report

AmosHersch — Mon, 06 Mar 2023 08:14:29 GMT

Seems that you are following the right sample.

Since the error seems to refer to the connection to the data source, the next thing I would check in the data sources used by the paginated report. For example if it uses a Power BI dataset as a data source you might need to add that dataset to the request. If it has other SSO-enabled data sources you might need to provide a token (identity blob) for them.

Re: Embedded paginated report

Rohan-25 — Mon, 06 Mar 2023 13:48:33 GMT

Yes, i am using Power BI dataset as a data source you can check sample code for request in the image below
It's for specific workspace

Re: Embedded paginated report

AmosHersch — Mon, 06 Mar 2023 14:28:48 GMT

Just wondering, it the dataset for the Power BI report and the dataset (data source) for the paginated report the same? If not I would expect to see 2 datasets in the list. Also if the dataset is a proxy to other dataset, both should appear.

The Service Principal must have access of course to all relevant datasets (member in the workspace).

Besides that I don't see any obvious reason for the error you got.

Re: Embedded paginated report

Rohan-25 — Tue, 07 Mar 2023 05:24:25 GMT

Yes, the dataset for the Power BI report and the dataset (data source) for the paginated report is same
The Service Principal is member in the workspace, can you please tell me that where i can check for other access?

Re: Embedded paginated report

AmosHersch — Wed, 08 Mar 2023 11:29:22 GMT

No other access to check that I'm aware of.

Last things I would check is that XMLA is enabled in the tenant settings (admin portal), and in the capacity level.

If so, then I would suggest creating a support ticket

Re: Embedded paginated report

Rohan-25 — Thu, 09 Mar 2023 10:33:08 GMT

XMLA is also enabled (image attached)