Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
Brief Architecture Summary:
We have a SaaS solution with a web app and use Power BI Embedded for the Analytics. Users Interact with reports that are embedded within the webapp using App owns data. We enable self-service for clients using the Power BI REST Apis to allow them to upload, edit, and view reports. Each client has their own Web App, Azure Analysis Services Instance & Power BI Workspace.
Issue:
When a client uploads a Paginated report Via our Web app, We enable this through the REST Api using Service Principal to get an embed token (recommended to use service principal in the Microsoft Documentation).
The report embeds/Uploads successfully BUT will not display/render since the dataset is owned by the Service Principal once uploaded.
The only way to get around this is for the Power BI Service Admin to manually edit the dataset for this report and take over the credentials from the Service Principal. Then the report renders for the user.
As an ISV serving many clients, manual steps like these are not sustainable at all.
We tried using a Master user to get an embed token but this fails to upload a Paginated RDL file with the error below.
(Master User works to get embed tokens for normal PBIX files but not for RDL files)
I have heard that the Service Principal works this way "By Design" but it is a fundamental issue if we can get an embed token and upload using the Service Principal BUT not allow the report to render and display.
Please assist urgently with enabling a sustainable solution to get this process to work smoothly.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.