Dynamic Datasource Changein Direct Query

[SuryaRS]

Hi All,

I have a requirement of changing the database dynamically based on the logged in user.

Requirement is described below:-
I have 5 Azure Databases DB1,DB2,DB3,DB4 and DB5. The schema is same in all the databases but the data is different. I have another database and that database is having the configuration table as below:-

email	DatabaseName
User1	DB1
User2	DB2
User3	DB3
User4	DB4
User5	DB5

The requirement is to change the database dynamically in PowerBI based on the logged in user.
Here user is accessing the powerbi report from the dotnet application.The requirement is if a user is clicking on the powerbi report from the application, the report should fetch data only from the corresponding database.For ex:if user1 is accessing the report then he should be able to see the data from DB1 only. Is there any way to implement this dynamic datasource change in Direct Query without passing Database name from the frontend as a parameter ?

[amitchandak]

@SuryaRS , You can change it dynamically, but I doubt you can control it using URL

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

As you using .net application, you can change report url, pointing to these dbs

[SuryaRS]

Hi Amit @amitchandak 
Is there any way to dynamically change the datasource without passing databasename as the parameter in Direct Query?

Thanks