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

Getting Data from multiple source(Connection) in one Report

Is is possible to get Data from Multiple service in one Report like
SQL server, Oracle, SAP and RedShift ?
If yes, can we do composite tables i.e Diect Query to SQL Server and Oracle and import for other SAP & RedShift etc ?
I am assuming we can later join those table coming from different Source to produce the Reprot.

1 REPLY 1
Resident Rockstar
Resident Rockstar

HI @nssidhu ,

 

Yes, you can use multiple Data Sources in a report.  That is part of the ability of Power BI that makes it so popular.  And, yes, you can now use composite models where you use Import and Direct Query.  I have included articles about both of these below.

 

Here is an article on using Import and/or Direct Query:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

 

And, this article is about composite models.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

 

 

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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!.

Top Solution Authors