Connecting to the source

[stribor45]

In my organization there is a report available lets clal it report A.  when i look at this report in service I can see this report and I can also see its semantic model as well. How can I create my own pbix and connect to this model to create my own report with different visuals etc. I was hoping to find dataset for this report in service but could not find any. 

[Anonymous]

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.

[Gabry]

Hello,

not sure, do you need to connect to the semantic model from powerbi desktop?

Just click on get data and select semantic model then chose the workspace and then the semantic model. You need build permission on the semantic model I suppose

[stribor45]

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?

[Gabry · Accepted solution]

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.