Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi experts,
Does anyone know if theres any effeicient way of going from importmode to DirectQuery?
//Niklas
Solved! Go to Solution.
hi @soderqvistn
As far as I know, it does not work. And think about it, there is a good reason to that:
- What to do, if you have changed the model in your file after the import?
- Or other way around: What do you do, if the server changed a lot, but your local model did not? A lot of conflicts would come up.
- Further, please note that in the "imported"-model, you can model the relationships yourself and also the data structure etc.. This would get ripped apart, if you use the direct query.
My recommendation:
Rebuild it.
Regards,
Lin
hi @soderqvistn
As far as I know, it does not work. And think about it, there is a good reason to that:
- What to do, if you have changed the model in your file after the import?
- Or other way around: What do you do, if the server changed a lot, but your local model did not? A lot of conflicts would come up.
- Further, please note that in the "imported"-model, you can model the relationships yourself and also the data structure etc.. This would get ripped apart, if you use the direct query.
My recommendation:
Rebuild it.
Regards,
Lin
I'm afraid it is not possible, although you can find some eager approaches to implement this, however, it comes with some risks.
recommendation is to rebuild, which shouldnt take much time.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |