Change Direct Query mode to Import mode from inside Power Query editor

[Anonymous]

Hi, is it possible to change the storage mode from inside the Power Query editor. I know that the mode can be changed from outside the PQ editor, but was curious if this featue is available inside. Thanks

[amitchandak · Accepted solution]

@Anonymous , I doubt so. But, what you can do; is add a transformation that is not supported in direct query and then it will ask it to convert to import mode, opt for import mode and check