Forum Discussion
Go from Importmode to DirectQuery?
Hi experts,
Does anyone know if theres any effeicient way of going from importmode to DirectQuery?
//Niklas
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
2 Replies
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
