Dynamic connections implementation in Power BI

[rambabunaidu]

Hi,

Facing issue to Implement Dynamic connections in Power BI.

 Requirement:  

ConsumerID ServerName DatabaseName UserName Password

consumer1   server1         db1                    sa              1234

consumer2   server2         db2                    sa              1234

consumer3   server3         db3                    sa              1234

 Above details are the consumer info related which are available in SQL server table. 

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. 

could you please help on the above requirement?

[v-shex-msft]

Hi @rambabunaidu,

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.

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 to get it working!

RLS with UserName()

Regards,

Xiaoxin Sheng

[rambabunaidu]

Its not in power Query. Development in Power bi desktop.

ConsumerID ServerName DatabaseName UserName Password

consumer1   server1         db1                    sa              1234

consumer2   server2         db2                    sa              1234

consumer3   server3         db3                    sa              1234

Table 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.

[v-shex-msft]

Hi @rambabunaidu,

>>Its not in power Query. Development in Power bi desktop.

Power bi desktop use power query to connect these datasource.

Current power query not contains functions to get user info, it only available on dax and it is impossible to pass to power query level.  So I want to suggest you to connect and combine all datasources then use dynamic rls with dax function to filter these data.

Regards,

Xiaoxin Sheng