Forum Discussion

alanatnfa's avatar
alanatnfa
Frequent Visitor
4 years ago
Solved

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

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 ...
Need Help
  • alanatnfa's avatar
    alanatnfa
    3 years ago

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

     

    Thanks

    All

alanatnfa's avatar
alanatnfa
Frequent Visitor
4 years ago

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's avatar
    A3-POWERBI
    New Member
    2 years ago

    Hi,

     

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