Change from Import -> DirectQuery retrospectively

[Anonymous]

I have a report and in which all data comes in from a SQL database. 

When creating the report I used the Import option. 

Is it possible for me to change this to DirectQuery without having to rebuild the report from scratch ? 

[amitchandak · Accepted solution]

@Anonymous , refer

https://xxlbi.com/blog/switching-from-imported-data-to-directquery-or-live-connection-in-power-bi/

[nvprasad]

HI,

I think it is not possible to switch the connection type. However, just connect the table using direct query then copy the m-code form the advance editor and replace the existing table code which is connected through import mode.

Still it may not work. But give a try.

Thank You,

Regards,

Venkata Nalla