cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Multiple Databases

Hi Team,

 

I have to fetch combined data from 6 Data bases and create dashboards,all 6 are  SQL DB Servers, I used to do same Using a macro which loops from database-database and fetch me data, but how can i do it in desktop version.

 

Please help

 

Thanks,

T.V.P.Ramakrishna

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Multiple Databases

Just create a query for each database. If you need to append or merge them together then create an Append or Merge query after creating your individual queries.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Regular Visitor

Re: Multiple Databases

Thanks For the Reply, but while appending  it is taking me to Joins which are done by  matching column values together-- this is creating a wrong Merged Sheet. below is the scenario.

 

Database1  and Database2 both have columns--  Bug, event name, release name. but these  two can not be joined as values in them are  different.  while trying  to merge/append queries is taking Bug.id which is a just number also common in both databases, say if i have 20 rows  in DB A  and 5 Rows in DB B , merge (All joins tried, with Full outer join) is giving me 20 * 5 = 100 Rows. which is very incorrect for analysing  what my expection is  just adding DB B values below DB A Values 20 + 5, and  clubbed table should be like below.

 

Bug      event    release

DB A values

DB B Values

 

Also, i have 118 Databases in my server i used to fetch all record at one click with macro with looping runing into all db's. Expecting same kind of workaround here in Power BI is that possible ?

 

Please help and make me understand if i am wrong .

 

 

 

 

Highlighted
Community Champion
Community Champion

Re: Multiple Databases

If your two database use the same (or similar) columns, an append should be exactly the 20 + 5.  By your description it sounds like you clicked "Merge Queries" instead of "Append Queries"?

Highlighted
New Member

Re: Multiple Databases

Hi,

 

I am making such report manually and want to automate it. I am new to this field and any help or guidance will be much appreciated. 

 

I have 7 different databases and I have combined them all resulting in a summarised compiled report. I have to send this every month. I was thinking of creating a model and just the data gets refreshed every 30 days. 

 

I was researching on Power BI desktop as we have the license for same. Any directions to proceed?

Highlighted
New Member

Re: Multiple Databases

Hi,

 

I am making such report manually and want to automate it. I am new to this field and any help or guidance will be much appreciated. 

 

I have 7 different databases and I have combined them all resulting in a summarised compiled report. I have to send this every month. I was thinking of creating a model and just the data gets refreshed every 30 days. 

 

I was researching on Power BI desktop as we have the license for same. Any directions to proceed?

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors