Allow more than one data source for Direct Queries.

[David_Botzenhar]

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

[nishalit]

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

[janec]

I have a Azure SQL database with lots of data that I am using successfully with PowerBI and direct query. This database has customer numbers but not names. I have a different database that has the customer list and I want to use the names to display but as soon as I try to add this second (small) database it says it needs to import the data from the first database. This is not possible as it is too big. My queries will be mostly against the one datasource but I need to use a "dictionary" type table from a different datasource to add more information to the report result.

[beneuto]

A common requirement is to filter large transactional data sets against a small list of customers. Forcing an import to make that join can be prohibitive. QlikSense allows such connections to be made with the large data source still accessed directly for potentially near instant results.

[zara_laheyjames]

We don't (yet) have a data warehouse, so many of my reports are running off multiple data sources. The ability to have direct query from multiple sources would be invaluable.

[DAVEFR]

I have a service supported by a distributed system each with its own SQL server I need to consolidate data from all these SQL instances to correctly reflect the service metrics. So this would be invaluable to me as well.

[beneuto1]

A common requirement is to have a fairly small list of say customer ids from a campaign management system (lets say around 1000) and then need to match that list against transactions (we could be talking billions) to get total spend for those customers. The necessary integrations have not yet been made in the data warehouse and we just want to prototype the concept. Essentially what we need is for the 1000 customer ids to be pushed down to a direct query so that the join is performed in the data warehouse (dirty read only solution: use a very large IN clause; cleaner read/write solution: create a temp table for the customer ids and join). QlikSense can do this.

[akhelif]

We are getting by, by creating cross database views, but it is not ideal. Please consider this feature as it would tremendously help companies with legacy databases.

[justin_wicks]

This is an essential feature and needs to be implemented ASAP!!!!

[cynthia_jiang]

This is an essential feature that will enable the self-service reporting against multiple cloud based data sources. Please include it in your next Power BI release.

[tzhu]

Import multiple data source first before can join is a deal breaker for broad adoption of the Power BI competing with tableau and other BI tools.