Forum Discussion
Multiple reports connected to same dataset: Cannot load model error
I believe i have discovered the problem and solution to this issue. Over the last few months, Microsoft has been updating how datasets can be shared and accessed across Workspaces. There are some tenancy level restrictions that can be put in around this, but also some additional restrictions that can be placed around datasets directly. Users need the "build" permission to access a dataset in Power BI Desktop.
From what I can tell, when you upload this model the "build" permission is not always given. For datasets that i've had there for a while my username already has "App, Reshare, Build". On my development model, which is newer, I only had "Read, Reshare".
To fix the issue you need to do the following:
- Navigate to the workspace using the Power BI Service with your web browser
- Find your Dataset and look for the "Manage Permissions" option. You'll find this in the ... menu
- Look for your username in the list and select the ... menu on your data row
- Select the "Add Build" option.
- Open your PBIX file that connects to this dataset. This should now work.
My model was working yesterday, but not today. I'll do some more monitoring to see if the build permission is being stripped periodically. This issue is appearing for me in the older style of workspace, so that might be part of the issue.
In case someone stumbles on this in the future, my username is part of the tenancy dataset certifiers so that part of the tenancy options should not be causing any issues.