Warehouse default semantic model: Build permissions

[cw88]

Hi, 

i want to assign build permissions (to a user without rights in the workspace) on the default semantic model, but can't do that because the "add user" button is not displayed.

Is this not possible? Or should i create a separat semantic model to share?

Thanks!

[dheerajpandey11]

I hav given connect, and all object level permission from warehouse sql endpoint and i am a workspace meber with build permission i am getting this error while connecting through sql database inside get data in power bi


 Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)

[cwlu88]

Hi @AndyDDC ,

correct, that is what i do, but the build permissions doesn't appear. Seems to be a bug on my warehouse, i opened a ticket. 

Thanks for your support!

[AndyDDC]

Hi @cw88 you need to add the users (or groups) by going to the Manage Permissions in the Warehouse settings and ensure "Build reports on the default dataset" is selected.

[cwlu88]

Hi @AndyDDC ,

I have tried, but the user does not appear in the dataset permissions... 😞

[AndyDDC · Accepted solution]

Just to confirm what you're doing.  On the Warehouse itself (not the semantic model), click the elipsis and select Manage Permissions.  Click Add User and ensure "build reports on the default dataset" is checked.  Then click Grant.

You should then see that user appear in the semantic model Manage Permissions screen.