Forum Discussion

Rahulsingh's avatar
Rahulsingh
Icon for Helper I rankHelper 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 

austinsense's avatar
austinsense
Icon for Impactful Individual rankImpactful Individual
10 years ago

If you want one report where you can select the data you want then all the data has to be in one data model ...

 

  • You can use the query editor to create 23 separate queries (sounds hard but you just create a query for one of the views and then duplicate it and change the data source).
  • You probably want to add the same column to each query indicating which database it's from
  • You'll then append all the queries together

The nice thing is once you've built this you'll never have to build it again - this is you being nice to your future self :)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

You'll then append all the queries together => could i ask more, in case append it, how about database size? is this double?