Skip to main content
Microsoft Idea

Power BI

Completed

Allow more than one data source for Direct Queries.

Vote (641) Share
Botz's profile image

Botz on 08 Feb 2016 01:24:30

In order to make Direct query more useful it needs to support data from more than one source.

Administrator on 17 Nov 2018 02:49:10

Composite models, which lets you combine multiple direct query sources in one model along with import sources, is now generally available with our November release: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#compositeModels

Comments (51)
Botz's profile image Profile Picture

mainul on 05 Jul 2020 23:13:56

RE: Allow more than one data source for Direct Queries.

I soo need this, multiple live connection is a absolute necessity now.

Botz's profile image Profile Picture

Mike Foss on 05 Jul 2020 23:13:50

RE: Allow more than one data source for Direct Queries.

They should create similar functionality to Power Pivot. In power Pivot you can pull multiple data sources in regardless of type. This would truly simplify some efforts in creating a one stop shop type of report.

Botz's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:12:31

RE: Allow more than one data source for Direct Queries.

It's crazy that this is not supported...

Botz's profile image Profile Picture

Mitesh Bhadani on 05 Jul 2020 23:12:27

RE: Allow more than one data source for Direct Queries.

We need this feature to join data from various databases rather pulling everything to the single database. Please act and make this a priority for coming release.

Botz's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:41

RE: Allow more than one data source for Direct Queries.

ASAP! Please

Botz's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:41

RE: Allow more than one data source for Direct Queries.

ASAP PLEASE

Botz's profile image Profile Picture

Johnny Johansen on 05 Jul 2020 23:09:46

RE: Allow more than one data source for Direct Queries.

Please implement this feature asap!

Botz's profile image Profile Picture

masoud taheri on 05 Jul 2020 23:08:50

RE: Allow more than one data source for Direct Queries.

Allow more than one data source for Direct Queries.
In order to make Direct query more useful it needs to support data from more than one source & Multiple Cube ,...

Botz's profile image Profile Picture

Mr. X on 05 Jul 2020 23:08:34

RE: Allow more than one data source for Direct Queries.

2 Years left, nothing happen

Botz's profile image Profile Picture

Greg on 05 Jul 2020 23:06:10

RE: Allow more than one data source for Direct Queries.

Sometimes I do not understand Microsoft.
This feature is really necessary for professional and large company.
This is not "cosmetic" (export excel, powerpoint, filter...)
This is essantial to use PowerBI and cross database.

Please, start development