Getting Data from multiple source(Connection) in one Report

[nssidhu]

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.

[collinq]

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!