Srinivasan Turuvekere on 22 Oct 2015 21:26:20
Allow direct query tables and imported tables to coexist in a single model with ability to create relationships between them.
Administrator on 17 Nov 2018 02:47:52
Our composite models feature, which lets you combine import and direct query sources in one model, is now generally available with our November release. Read more about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/#compositeModels
- Comments (31)
RE: Allow mixing direct query and imported tables in a single model
This is really essential for making power BI more powerful
RE: Allow mixing direct query and imported tables in a single model
This would be huge for power users.
RE: Allow mixing direct query and imported tables in a single model
would be nice if this can be at object level in the dashboard pages.
RE: Allow mixing direct query and imported tables in a single model
It is a crucial issue that can solve many database level integration workarounds.
RE: Allow mixing direct query and imported tables in a single model
We definitely need this one...
RE: Allow mixing direct query and imported tables in a single model
It is almost funny in how many cases my end users wish to see the finest grain details for a specific customers when they start looking deeper into some phenomenon. Any way I can easily enable them to dig deeper in to the details without exploding the model is welcome. The ability to switch to another page in the report retaining filtering values is great, now to get further the detail-page would need to fetch the most detailed data over a direct query.
RE: Allow mixing direct query and imported tables in a single model
Definitelly, something we need. Also, mixing multiple sources in the direct query (for example, 2 different sql servers)
RE: Allow mixing direct query and imported tables in a single model
We have 1500 power bi licensed users... it's really a problem explaining that the self service reporting tool doesn't allow mashups of custom data with formal data!
Biggest feature request from our organisation!
RE: Allow mixing direct query and imported tables in a single model
This is a common scenario in many of my projects. If it is self service BI then customer need to import their own Excel sheets to a direct query connection model. This is a very severe limitation.
RE: Allow mixing direct query and imported tables in a single model
This is the entire reason my company needs Power BI! I started using BI and now that I have access to our SQL Server, I came to find out I cannot combine the data I need to combine unless it becomes possible to use DirectQuery from 2 different databases on the Server plus mix in some imports.......