Forum Discussion
How to change back to live connection
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.
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?