Forum Discussion
Power BI Embed - issue with Paginated report visual
Basically most errors in such cases are related for you "Generate token" request. Basically it should include the ID of the Power BI report, the ID of the Paginated report, the ID of the Power BI dataset with "xmlaPermissions" parameter set to "ReadOnly". Other values might depend on your specific configuration (datasources, RLS, etc.).
Did you see this sample of such request: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-faq#how-can-i-embed-a-power-bi-report-that-contains-a-paginated-report-visual-
Any help please, I have done all as suggested:
1.) In Embed code used "allowEdit: False", and passed reportIdList
2.) Changed data-source of Paginated report to be XMLA EndPoint of dataset, and hard-coded User Id/Password for service principal {user id: addid:<applicationid@tenantid>;Password:<application-secret>} ..
but still no luck. I even just trying to embed "paginated report" alone in application, and that too doesn't work.
please any advise and help.
1. Did you include the dataset ID in the "generate token" request, and specified "xmlaPermissions" as ReadOnly?
2. Can you please share how your generateToken request looks like (you can use fiddler)?
3. Please share the ID of the failed request (where you get "bad request" from Power BI). The response message should include request ID in the header.
Code sample that are availabel doesn't support dataset construct with "xmlapermissions", so I am trying to figure out to create namedspace and reference in GenrateToken code.
generateToken fiddler capture is so far not getting "DatasetId" passed to it, and IF I use report "GenerateToken" function for RDLReport embed, it always fails with error message in embed app "Unable to contact underlying data source. ata source is available, your credentials are correct and that your gateway settings are valid."... which is strange as I am able to succesfully use Paginated report in service and my data-soruce is working fine.Anonymous did you see this sample request to generate the token? I belive yours should be similar.
Yes i have seen this MSDN document, and even all REST API documents. But I am using "sample Power bI Developer Embedded solution" from this document page (.Net Framework; Apps owns data/Embed for your customer). these solutions doesn't have dataset construct to refer as required for Paginated Report REST API call with permission. That is where I am stuck currently. 😪