Embedded paginated report

[Rohan-25]

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)

[AmosHersch]

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.

[Rohan-25]

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 

[AmosHersch]

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.

[Rohan-25]

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 

[AmosHersch]

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.

[Rohan-25]

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?

[AmosHersch]

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

[Rohan-25]

XMLA is also enabled (image attached)