Power BI Embedded - Connect to various data sources

[Everton]

Hi,

If I were to use Power BI Embedded in my application where each user has their own database, how would I connect to different data source depending upon the user? What is the recommended approach?

Thank you 

[v-xicai · Accepted solution]

Hi @Everton  ,

Currently, the RLS is available for the embedded reports.

From this document Row-level security with Power BI Embedded, we know you can filter data with RLS by using one of the options below.

Configuring roles in a Power BI report.

Configuring roles at the data source level (Analysis Services live connection only).

You can learn more:

https://community.powerbi.com/t5/Developer/Power-Bi-Embedded-RLS-with-REST-API/td-p/230192,

https://medium.com/henngeblog/simplest-rls-row-level-security-on-power-bi-embedded-a6b0265453b1.

Best Regards,

Amy

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

[Everton]

Sorry, I didn't explain my situation very well. We are a software vendor. In our software we want to distribute a report. The report needs to connect to the users' own instance of their database. The solution is distributed on Azure. I guess what I need is some sort of variable I can change to connect to different data sources.