Dynamically Switching Power BI Embedded Reports Based on User Context

[odraode_]

Hello everyone,

I'm tasked with creating a web-app for my organization that needs to embed a Power BI report. Every user accessing the web-app should be able to view their own Power BI report, which will be published in either their personal workspace or one of their choice.

As I envision the application, there will be a table that stores the association between userId, workspaceID, and reportID. Hence, for each logged-in user, the web-app will use the workspaceID and reportID parameters to dynamically change the report being displayed.

I have a few questions:

• Is this feasible?
• Does a user need to have a Pro license to view their own report in the selected workspace?
• I’m confused about whether to use Power BI Embedded or Premium capacity. Which one would be more suitable for my needs?

Thank you very much in advance!

[v-tianyich-msft · Accepted solution]

Hi @odraode_ ,

Yes, your plan to dynamically switch Power BI reports based on the logged-in user is feasible. You can use the Power BI JavaScript API to dynamically set the `embedUrl` and `reportId` based on the user's workspace and report ID.

For more information on embedding Power BI reports, please refer to:https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-sample-for-customers

If your workspace is in a Premium capacity, users can view their own reports without a Pro license. However, if the workspace is not in a Premium capacity, users will need a Pro license to view their own reports.

Finally.This depends on your specific needs and budget. Power BI Embedded is a more cost-effective solution if you only need to embed reports in an application. However, Power BI Premium provides additional features such as the ability to share content with external users, higher data capacity limits, and more frequent data refreshes.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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