Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nssidhu
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
collinq
Super User
Super User

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!

 

 

 




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors