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?

[Feiiiry]

It is possible. I just found the way to do it today.

Step1: Delete all data sources in the report.

Step2: Go to option, then go to 'Published semantic model settings' and enable this option. 

Step3: go to Getdata to get the semantic model you need.

that's it!!!!!!! 

then you'll see it changed from direct query to live connection at the bottom right 😉

[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.

[PowerBIUser2jan]

Hi Team_Jing,

You said When you convert a model from Live Connection to DirectQuery, it will load the model into Power BI Desktop. I want to understand when we move from live connection to direct query, does powerbi make a local copy of the model, so that whatever changes I make in the model is local and does not push back to the original model that is owned by another team. I want to understand the consequences, whatif I delete ceratin measures or edit calculations in the local model, will that reflect on the original model for which the connection was changed from live to direct query. That is because the model is created and managed by another team and they have provided build rights to anyone who wishes to create composite models on top of this model, and I make enhancements so I wanted to understand the consequences of editing?