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.
Hi stribor45
If your report is using a live connection, you will see the following warning message when clicking transform data into Power Query or connecting to a second data source.
You can change to DirectQuery connection mode to build a composite model so that you can connect to the semantic model in the Service in your own report.
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Can't find any semantic model in Service? Please check workspace roles or semantic model permissions.
Make sure the workspace role is Contributor/Member/Admin.
Make sure there are Build permissions for the semantic model you want to connect to.
Semantic model permissions - Power BI | Microsoft Learn
Manage semantic model access permissions - Power BI | Microsoft Learn
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.