How to embed a power bi paginated report when there's no dataset_id

[tcliu1990]

I can go through normal power bi report by the example here https://github.com/microsoft/PowerBI-Developer-Samples/tree/master. But when I try to embed a paginate report, the response of this endpoint https://api.powerbi.com/v1.0/myorg/groups/group_id/reports/report_id/ doesn't have a dataset_id like normal report. So I can't get the embed token for next step by endpoint https://api.powerbi.com/v1.0/myorg/GenerateToken. I noticed there's another body I can send, which is data source identities. But I can't find a endpoint to retrieve identityBlob. The response of this endpoint https://api.powerbi.com/v1.0/myorg/groups/group_id/reports/report_id/datasources only gives me datasources information. So how to embed a powerbi paginate report without a dataset_id

[v-yangliu-msft · Accepted solution]

Hi  @tcliu1990 ,

This is the related document, you can view this content:

c# - Power BI paginated report embedding without dataset using service principal - Stack Overflow

Solved: Embedded paginated report with PowerBI dataset - Microsoft Fabric Community

Embed paginated reports in your Power BI embedded analytics application - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[tcliu1990]

Hi @v-yangliu-msft Thanks for answering.

The second link really helps me. I got the dataset_id from sobe_wowvirtualserver-<DatasetID> . However, after I send this dataset_id to https://api.powerbi.com/v1.0/myorg/GenerateToken,  this endpoint. I got a new error: Cannot connect to dataset xxx with embed token because XMLA permissions are off

my xmla endpoint setting is read-only.