Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
Proud to be a Datanaut!
Private message me for consulting or training needs.