Add a local model returns an error on dataset access while i'm admin of the workspace

[RemyM]

Hello,

I have 3 production reports on my power BI Workspace and each one of them have their own semantic model.

I downloaded one of the report using a live connection to semantic model online. I want to add to this pbix report external data from an Excel. For this, I click on Transform Data and it logically asks me to "Add a local model".

When I do so, it returns this error "You do not have access to the underlying semantic model". For me it makes no sense because I am admin of the workspace on which the underlying dataset is.
Also note that if I do the same experiment by starting a blank report and sourcing the semantic model online from there, I can add a local model after without having the same error.


Can someone explain to me the difference and how I have this error ?

Thank you for your help.

Rémy

[Anonymous · Accepted solution]

Hi @RemyM ,

I don't have much experience with the api, but according to the documentation, the format should look like this.

Data source=powerbi://api.powerbi.com/v1.0/contoso.com/Sales Workspace

or

Data source=powerbi://api.powerbi.com/v1.0/myorg/workspaceName

When you download the Pbix file, do not try to add a local model first.

1.Click on Data Source Settings

2.Select the corresponding semantic model in this interface

3.Tenant ID changed to myorg,local model can be added normally

Best Regards,
Wenbin Zhou

[RemyM]

Hello,

Yes it works this way ! Thank you.

Only issue I have is that when I do that and then "Add a local model" and it auto refreshed the direct query connection to my semantic model, all visuals containing data groups are in error. It seems that Power BI data groups are not considered as groups anymore when used via a Direct query connection.

Power BI does not recognize field with the same name as it is not considered a data group anymore.

So I have to replace every data group field by the new field from direct query (see screenshots when it shows error but the field exists).

Regards,

Rémy