Power BI Embed and passing data from user interactions between it and the custom application

[CoryKoch]

Question:

How do you associate "Custom app" users with the Power BI Service?  In other words how do you pass Custom App user data to the Power BI Service?  For example is there a way to pass the Custom Apps userId or any other information through to the Power BI Service and then through to the Power Automate Flow?  This section Enforce data permissions makes it sound like this is possible, but I cannot find any concrete examples of how to do this.

Background:

Currently, we are working on a proof on concept for embedding Power BI Dashboards into Angular apps. In order to allow the user interaction with the embedded Dashboard to trigger events in the Angular app, we are using Power Automate buttons to trigger flows to Amazon SQS to push data onto the Queue which the frontend is listening for and then using the extracted data from the dashboard to continue with native Angular actions.  The problem we are trying to solve now though is how do we associate the Angular App users to the Power BI/Power Automate interactions. 

For Embedded Power BI, we are using a Service Principal and have been following the architecture outlined in the links below. This diagram is very close to what we are doing usage-scenario-embed-for-your-customers 

Links

• Tutorial: Embed Power BI content using a sample embed for your customers application
• Power BI usage scenarios: Embed for your customers

[CoryKoch]

@Microsoft Can I get a product person to look at this?

[SaiTejaTalasila]

Hi @CoryKoch ,

Please share more details on your business requirement.

You can try something with powerapps+powerbi 

Thanks,

Sai Teja 

[CoryKoch]

@SaiTejaTalasila ,

What would you like to know?  The business requirement is to embed Power BI Dashboards into an existing Angular project.  We have embedding the Dashboard into the Angular app working.  Now we are trying to see if it is possible for the Dashboards to support interactions between the Power BI Dashboard and the Angular app.  As I said in my initial question it appears that this is possible from the sources that I included however we are having problems figuring out how to pass the Angular application data between Power BI, Power Automate and the Angular app.

Example Scenario:

User clicks embedded dashboard in Angular App and is directed to details page where they can interact with the data.

GIVEN

That a user is logged into the Angular app and they are on the page with the embedded Power BI Dashboard.

WHEN

The user clicks an item on the Dashboard.

THEN

The user is taken to another Angular page within the Angular app where they can act on the selected data such as product types, date ranges, product states from the Embedded Power BI Dashboard.  The actions taken require interaction between the Angular app and the backend APIs at this point Power BI is out of the picture.

I am open to productive suggestions for using the Power BI Dashboards or Reports Embedded within an Angular application because that is the exact business requirement that we are trying to fulfill.  This is to potentially replace widgets in very large existing solution that is written in Angular so going some other route outside of embedding things in Angular is out of the question. 

To give technical background on this the solution is being designed and developed by a team that consists of a Full Stack dotnet developer, a frontend Angular developer and a Business Intelligence Developer.  So far we have the necesarry APIs in place that the Frontend is consuming to display the embedded Dashboards within the Angular app.  We are using the powerbi-client-angular and using the microsoft.powerbi.api.powerbiclient in the backend APIs to supply the information for embedding the Dashboard.

[Anonymous]

Hi @CoryKoch ,

Please check out the following links hope it helps.

Return data to PowerApps from a flow, build lists in a flow, and test a flow with previous run data ...

Power BI usage scenarios: Customizable managed self-service BI - Power BI | Microsoft Learn

Embed Power BI report in a Power BI embedded analytics application for your customers - Power BI | M...

Best regards,

Lucy Chen

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

[CoryKoch]

Hi @v-xinc-msft,

Thanks for taking the time to respond, but the links you've shared don't directly address my specific question about associating custom app users with Power BI Service and passing user context.

I'm looking for concrete guidance on:

• How to map custom app user identities to Power BI
• Techniques for passing user information through embedded reports
• Methods to link Angular app users with Power BI interactions

Would you or anyone else have insights into these specific challenges? I'm eager to learn and appreciate any targeted advice.