Embed Paginated Report Power BI Dataset - App Owns Data (Embed for Customer)

[alanatnfa]

Hi all

I am using Power BI Embedded SKU A1, Gen 2.  I have created a workspace, Azure App, given the app all API permission to the PBI Service, addedd the service principal into a security group and givent that security group admin access tot he workspace that has the embedded capacity.  (Understand that the privelages right now are above required, but wanted to ensure that was not the problem)

I am using Postman to genearate access tokens, embed tokens and retrieve the embedded url.  I am then using the Power BI Playground to test out my report.

For a normal PBI report, I can get this working fine and even down to RLS, works great.

However for a Paginated report, I can get it working under 2 conditions, a report with no data (not too useful!) and a report with data entered directly into the report (also not that useful!).  These render correct in the playground.

However once I use a PBI Dataset (import or direct query), the report does not render and I receive the error

I have tried many way to get this to work but to no avail and I am note sure what I am missing.  If I follow the MSFT instructions for the HTTP payload from the following location

https://docs.microsoft.com/en-us/rest/api/power-bi/embed-token/generate-token#example-of-generating-...

I have tested multiple ways of creating the payload and end up with the same error message each time.

Can someone please assist and advise on what I am missing?

Thanks

[alanatnfa · Accepted solution]

This is now resolved and working.  Had to open a MSFT support call to obtain the correct payload required.

Thanks

All

[A3-POWERBI]

Hi can you please share the solution to help others?

Thank you!

[alanatnfa]

Hi @Anonymous 

Yes using service principal.  I have paginated reports working correctly when using a non-sson datasource, ODBC/MySQL and I can use the embed token in the playground and the report works correctly.  The problem is with a Power BI Dataset that requires SSON.  All of the above requirements are covered, only this one scenario does not work.

I have tested using the PBI Dataset and also by using the XMLA end point and embedding the authentication within the RDL file using the app:id@tenantid and the secret as the password.  The report renders fine in the report builder and in the PBI Service.  The report though does not render once I use the embed token method.  It may be the JSON payload and the documentation for this scenario is not great.  It mentions needing to pass an identiy blob, but does not explain what this blob is and where I should obtain it from.

Thanks for the help

[A3-POWERBI]

Hi,

Do you mind sharing the payload you used for ODBC connected paginated report?

[Anonymous]

Hi @alanatnfa ,

Which verification method are you using:

Embed content in your Power BI embedded analytics application - Power BI | Microsoft Docs

Do you add the user to the workspace corresponding to the dataset and set the role to the Contributor.

Roles in workspaces in Power BI - Power BI | Microsoft Docs

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.