Forum Discussion
Helper IPower BI Embedded - Connect to various data sources
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
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.
2 Replies
v-xicaiCommunity Support
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.
EvertonSorry, 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.