Import To DirectQuery

[Arul]

Hi All,

When I try to change from import to DirectQuery in Powery Query Editor, DirectQuery option is not coming up for the already imported file. Can anyone help me on this?

Thanks,

-Arul

[v-yalanwu-msft]

hi, @Arul ;

Accoridng to the official document , Can't change from import to DirectQuery mode: While it's possible to switch a model from DirectQuery mode to use import mode, all the necessary data must be imported. It's also not possible to switch back.

You may also take a look at this idea.

Best Regards,

Community Support Team_ Yalan Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arul · Accepted solution]

@v-yalanwu-msft ,

Thank you. This is the exact answer what I am expected.

[amitchandak]

@Arul , in the data model view, Click on the table, open property pane -> Advance.

what mode you see there, if it direct, try to change to import

[Arul]

@amitchandak ,

My case is Viceversa Import to Directquery. Is it possible to change from Import to Directquery?