Forum Discussion

Rahulsingh's avatar
Rahulsingh
Helper I
10 years ago
Solved

How to connect multiple database with same table in Power BI

Hi Everyone   I have a unique situation where my client has 23 databases for their companies with same table and views. they want a report in which they can filter the report by each company and vi...
Need Help
  • Rahulsingh's avatar
    Rahulsingh
    10 years ago

    Hi Ankit, 

     

    Is it possible to get an example on how to create a database connecion parameter . Thanks 

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

Rahulsingh

 

You just need to create a query parameter and populate it with database name, then use this parameter in source Power Query. See screenshots below:

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
8 years ago

@v-sihou-msft

 

I'm in a similar situation,

what I want is to do is to read tables from the different database on Azure, and then, for example, calculate the net profit for a period from all database.

 

can u post a guide how to do that?