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.