Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone,
I would like to understand beacause is not possible use Direct Query and Import in the same time on Power BI?
Thanks,
Solved! Go to Solution.
Hi @nanojau,
Power BI used to be a 'one or the other' approach with DirectQuery vs. Import, but this has changed recently. In a lot of cases it is possible to create composite models that can mix these data sources. Here's the MS documentation on it. The doc also contains an example.
There are some exceptions where you can't use composite models, though. If you're connecting to any of the following sources, they can be DirectQuery only (detailed in the Limitations and considerations section):
Here's some further reading/viewing into composite models that may help:
I hope this helps you out.
Daniel
If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi @nanojau,
Power BI used to be a 'one or the other' approach with DirectQuery vs. Import, but this has changed recently. In a lot of cases it is possible to create composite models that can mix these data sources. Here's the MS documentation on it. The doc also contains an example.
There are some exceptions where you can't use composite models, though. If you're connecting to any of the following sources, they can be DirectQuery only (detailed in the Limitations and considerations section):
Here's some further reading/viewing into composite models that may help:
I hope this helps you out.
Daniel
If my post helps, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
3 | |
2 | |
2 |