Forum Discussion
Add a local model returns an error on dataset access while i'm admin of the workspace
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 Workspaceor
Data source=powerbi://api.powerbi.com/v1.0/myorg/workspaceNameWhen 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
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 Workspaceor
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
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