Forum Discussion
Dynamic SQL datasource selector
HI mferraricloudsu,
It sounds like indireclty getting data requirement. You can store these company and correspond server information to a table and use power bi to getting data form that table.
Then you can simply use M query to getting data from specific row of the table records. (use these field values as connection strings to getting data)Regards,
Xiaoxin Sheng
Anonymous my problem is not to bind record to users, my goal is to create one single Power BI template and attach dynamically new datasources (each one is a SQL database, one for each company). So, if a new company will be created, Power BI report will recognize automatically that a new datasource is available and can show the data of new company/db.
HI mferraricloudsu,
It sounds like indireclty getting data requirement. You can store these company and correspond server information to a table and use power bi to getting data form that table.
Then you can simply use M query to getting data from specific row of the table records. (use these field values as connection strings to getting data)
Regards,
Xiaoxin Sheng