How to change back to live connection

[matt3943]

I have added a local model to go from a live connection to direct query. 

How do I go back to a live connection after making this change?

[matt3943]

Thanks for the response

Luckily Power BI had a file saved where it was still connected by live connection so I got away with one there. Direct Query definitely has its perks but Live Connection is definitely quicker and for that report that was the priority

[v-jingzhang]

Hi @matt3943 

It is not supported to change the connection from DirectQuery to Live Connection. This is by design. When you convert a model from Live Connection to DirectQuery, it will load the model into Power BI Desktop. When you use Live Connection, the model is located in the data source side and consume the resource in the data source. It cannot remove the local model to change DirectQuery back to Live Connection. 

You have to create a new pbix file to connect to the same data source with Live Connection again.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.