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 

Rahulsingh's avatar
Rahulsingh
Helper I
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?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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?