Forum Discussion
Connecting to the source
You can connect to a semantic model either via a live connection (which doesn’t allow access to the Data View) or through DirectQuery, with all the associated limitations.
If you choose DirectQuery, you can use Power Query to make modifications, but remember to account for the constraints of DirectQuery.
There are no other connection methods. If you create a local model and make modifications, the original model remains unchanged. Similarly, using a live connection will not alter the original model.
To change the original model, you need to publish your updates to the service and overwrite the existing model.
You can find more information in the documentation here: Power BI Report Lifecycle.
I want to be able to go to power query as well. This is what showed when I clicked on transform data. can i make my own copy of the model without affecting exisiting?
You can connect to a semantic model either via a live connection (which doesn’t allow access to the Data View) or through DirectQuery, with all the associated limitations.
If you choose DirectQuery, you can use Power Query to make modifications, but remember to account for the constraints of DirectQuery.
There are no other connection methods. If you create a local model and make modifications, the original model remains unchanged. Similarly, using a live connection will not alter the original model.
To change the original model, you need to publish your updates to the service and overwrite the existing model.
You can find more information in the documentation here: Power BI Report Lifecycle.