Forum Discussion

soderqvistn's avatar
soderqvistn
Helper I
6 years ago
Solved

Go from Importmode to DirectQuery?

Hi experts,   Does anyone know if theres any effeicient way of going from importmode to DirectQuery?   //Niklas
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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