Composite Model published to App - users without direct user permission?

[ttypical]

Hello,

In a workspace we have a new report published to App, the app audience is the entire organization, therefore the users are not having access to the workspace (Workspace A) or the semantic models itself. 
The report is built in composite model, the direct query connection is a semantic model (just import mode) from an Workspace B.

The users getting an error when they try to look at the report via the App.
I've tried to look around and found the user needs Read permission to the semantic model in Workspace B, but I do not know the individual users or even a group for them, as it is for all organization.
Can I somehow achieve that the end users are able to see the report in app without direct access to the semantic model in the other workspace (And without access to any of the workspaces). 
I was thinking if maybe if I change the mapping of the cloud connection to something else. I also have an enterprise gateway option but I'm getting lost how to achieve this. 

[ttypical · Accepted solution]

Unfortunately that option is not available on the semantic model dataset permission settings (neither workspace level). I've tried already but only users or groups are coming up, Everyone/Entire/All etc is not recorgnised.

[Poojara_D12]

Hi @ttypical 

Grant Build permission to "Everyone" or "Entire Organization" on the semantic model dataset in Workspace B via Manage Permissions. This allows users to view the report without workspace access.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[ttypical · Accepted solution]

Unfortunately that option is not available on the semantic model dataset permission settings (neither workspace level). I've tried already but only users or groups are coming up, Everyone/Entire/All etc is not recorgnised.

[Anonymous · Accepted solution]

Hi @ttypical 

If such a group does not exist, you can contact the IT team to create a security group that includes the entire organization. If possible, move the reports and semantic models to the same workspace. When the dataset and reports are in the same workspace, users do not need separate permissions when accessing through the application.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.