Go from Importmode to DirectQuery?

[soderqvistn]

Hi experts,

Does anyone know if theres any effeicient way of going from importmode to DirectQuery?

//Niklas

[v-lili6-msft · Accepted 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

[Anonymous]

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.