Forum Discussion
Users cant display visual on system with multiple live connections
Hi dcormiernj
When you publish a report based on the Proxy dataset, every time the user connects to Proxy there is a connection established between Proxy and Base. This connection is possible only if the user has the proper permissions on both Proxy and Base datasets. In other words, if the user does not have enough permission on Base, the error could appear.
the Viewer permission is not enough to use composite models. The missing part is the Build permission, which is not part of the permission provided when the user has the Viewer permission on a workspace.
In order to assign the Build permission on a dataset for Viewer users you have to:
- Select the Manage permissions context menu for the Base dataset
- Click the Direct access tab that lists the users that have access to the dataset
- Click the Add build context menu for the user that must be enabled to access Base through the Proxy composite model.
- Make sure that the user has now both Viewer and Build permissions on the Base dataset.
- Setting the right minimal permissions for a dataset is important in an enterprise environment, also to guarantee that security roles are correctly applied to the reports.
More details: Setting the right permissions for users of composite models
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dcormiernj ,
Could you tell me what is your data source? Does your dataset apply RLS? Maybe you can check your dataset.
If you publish your Power BI Desktop report to a new workspace experience in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace.
More details:Using RLS with workspaces in Power BI
I have also found a similar post ,please refer to it to see if it helps you.
Users with Contributor or Viewer permission receive "Cannot load model" error
- From the error it would appear that the dataset has RLS configured.
If it doesn't help, please provide more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you V-Polly for responding.
1. My data sources are other PBIX datasets. I Have three desktop systems and all published to BI service. I then created a new PBIX as a summary system which needs data from the other three. So I used "get data" and selected "Power BI Datasets". So the only source to this new system are the three Power BI datasets from the other three systems.
I then created visuals in this new system, published it to power bi service. And it works great. Except when i try to share the summary system. if the person i am sharing with only has viewer authority they cannot see the visuals. But if i copy the system (debugging) and remove all but one of the source datasets, they can see it fine.
I have to make them contributors to be able to see all visuals with the real system that includes all three files. I only want them to have view access.
2. Does my dataset use RLS? I dont know !!! Is RLS automatically added? or is it possible to set it up unknowingly? Is there a way i can tell if RLS is being used? And if so, can I or should I turn RLS off??
3. And yes I am publishing to the new work space. But I really dont know how to tell if RLS is on or not????
I am reviewing the links you gave me.
Thank you so much for trying to help me.
Hi dcormiernj
When you publish a report based on the Proxy dataset, every time the user connects to Proxy there is a connection established between Proxy and Base. This connection is possible only if the user has the proper permissions on both Proxy and Base datasets. In other words, if the user does not have enough permission on Base, the error could appear.
the Viewer permission is not enough to use composite models. The missing part is the Build permission, which is not part of the permission provided when the user has the Viewer permission on a workspace.
In order to assign the Build permission on a dataset for Viewer users you have to:
- Select the Manage permissions context menu for the Base dataset
- Click the Direct access tab that lists the users that have access to the dataset
- Click the Add build context menu for the user that must be enabled to access Base through the Proxy composite model.
- Make sure that the user has now both Viewer and Build permissions on the Base dataset.
- Setting the right minimal permissions for a dataset is important in an enterprise environment, also to guarantee that security roles are correctly applied to the reports.
More details: Setting the right permissions for users of composite models
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
