Import to direct query

Hello how can we change storage mode from import to Direct query?.Thanks

Hello @rush2bi,

Thank You for posting your query onto the Forum.

I’m attaching a screenshot below of one of the point from the documentation of the Microsoft.

Also providing the link of the documentation - “About using DirectQuery in Power BI”.

And lastly also providing a link where a query was asked onto the forum about the “Performance comparison between DirectQuery & DataImport” and some really great points were discussed in this post. Also the links of the queries posted onto the Power BI Community Forum.

Hoping you find this useful. :slightly_smiling_face:

Thanks and Warm Regards,

Refer other implications section under the given link of the documenatation -

Refer this blogpost where steps are provided to convert. Might be useful in your case.

Hi @rush2bi, did the response provided by @Harsh help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

Hi @rush2bi, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!