Dynamic connections implementation in Power BI

Question

Hi,&nbsp;Facing issue to Implement Dynamic connections in Power BI.&nbsp;Requirement: &nbsp;ConsumerID ServerName DatabaseName UserName Passwordconsumer1 &nbsp; server1 &nbsp; &nbsp; &nbsp; &nbsp; db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234consumer2 &nbsp; server2 &nbsp; &nbsp; &nbsp; &nbsp; db2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234consumer3 &nbsp; server3 &nbsp; &nbsp; &nbsp; &nbsp; db3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234&nbsp;Above details are the consumer info related which are available in SQL server table.&nbsp;Based on the Consumer login into the power bi, power bi needs to connect to related server and database using with username, password. for example, conusmer1 login into the power bi desktop then data should be get from server1,db1 using with username and password. same way for consumer2, consumer3.&nbsp;&nbsp;could you please help on the above requirement?

anonymous · Answer

Hi&nbsp;rambabunaidu,
&nbsp;
Current power query not support to get login detail information and create a dynamic connection based on it.
Login details in Power Query
For your scenario, I'd like to suggest you post this requirement to power query related forum for further support.
&nbsp;
In my opinion, I'd like to suggest you connect and combine these data source and create dynamic RLS to filter the records based on login user name.
Reference link:
Row-Level Security in Power BI Desktop
Power BI – Dynamic Row Level Security – Tips&nbsp;to get it working! 
RLS with UserName() 
&nbsp;
Regards,
Xiaoxin Sheng

rambabunaidu · Answer

Its not in power Query. Development in Power bi desktop.ConsumerID ServerName DatabaseName UserName Passwordconsumer1 &nbsp; server1 &nbsp; &nbsp; &nbsp; &nbsp; db1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234consumer2 &nbsp; server2 &nbsp; &nbsp; &nbsp; &nbsp; db2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234consumer3 &nbsp; server3 &nbsp; &nbsp; &nbsp; &nbsp; db3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1234Table info like above. Suppose Consumer1 Login with his credentials to the Power bi desktop then data should be get from server1, db1. same way consumer2 login with his credentials then data should get from the server2, db2... Based on consumer Dynamically needs to connect to server and database.If you need more info let me know.

anonymous · Answer

Hi rambabunaidu,
&nbsp;
&gt;&gt;Its not in power Query. Development in Power bi desktop.
Power bi desktop use power query to connect these datasource.
&nbsp;
Current power query not contains functions to get user info, it only&nbsp;available on dax and it is impossible to pass to power query level.&nbsp; So I want to suggest you to connect and combine all datasources then use dynamic rls with dax function to filter these data.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

Dynamic connections implementation in Power BI

3 Replies

Related content

Implementing RLS in Dynamic Subscriptions

RLS implementation under direct Lake connectivity

Implement Dynamic RLS with Azure Security Group

Dynamic ODBC Connection.

MDM implementation