Change live connection to import mode

[Anonymous]

Is it opssible to change the connection from live connection to import mode in Power BI, If yes how can we do the changes.

[v-gizhi-msft · Accepted solution]

Hi,

To my knowledge, i think there is no such function till now.

And i advise you trying to get data again by import mode and create same visuals.

Best Regards,

Giotto

[Tahreem24]

@Anonymous ,

Please see my solution at below post:

https://community.powerbi.com/t5/Desktop/How-to-change-one-table-direct-query-to-import/m-p/874680#M419419

[Anonymous]

Tahreem24, This will not work on my scenario because my dataset already established through live connection, now i want to move pbix file to live connection but that will not working for me. Please find the below screen shot and if you find any solution please share it back to me.

[Tahreem24]

@Anonymous ,

Currently there is no feature to change the Live mode to Import mode. You can give your vote to this idea. Please see the below link for your reference.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18556393-support-switching-ssas-connect-model-from-connect

https://community.powerbi.com/t5/Desktop/Change-Data-Source-Mode-from-Live-to-Import/td-p/649151