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)
RE: Allow more than one data source for Direct Queries.
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.