Error accessing default semantic model

Hi Bhargava05 

If the user only has access to a specific schema or folder, but the default semantic model references tables or objects outside their permission scope, the model fails to load for them, resulting in the error.
• Even if you assign “Build” or “Read” permissions on the semantic model, the underlying data access is still enforced at the Lakehouse level

Hi nilendraFabric  thanks for your reply.

I have given access to underlying schema at the lakehouse level as well, using one lake data access. So in that case it shouldnt throw the error, and also let me know if have any suggestions for my case where i wanted to give user access to only specific schema and also he can build reports based on that schema.

I know one lake data access can be used for Lakehouse and sql granular permissions for sql endpoint but following both of those didn't  work.

Hi Bhargava05 ,

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

v-kathullac  it didnt get resolved yet, i have a sceanrio where end user should be able to access default semantic model and build reports based on it. Would be able to guide me through the steps/permissions i need to implement to achieve above.

Hi Bhargava05 ,

Below are the few points which can resolve your issue.

• Publish your semantic model (dataset) to a Power BI workspace.

• Ensure the dataset is modeled correctly with necessary measures and relationships.

• Add end users or user groups to the workspace with Viewer role.

• Grant Build permission on the dataset explicitly to those users/groups.

• Optionally, make the dataset discoverable in the Data Hub.

• Instruct users to open Power BI Desktop → Get Data → Power BI Datasets → select the shared dataset.

• Alternatively, users can go to Power BI Service → Data Hub and click Create Report on the dataset.

• Users will build reports using a live connection to the semantic model.

Regards,

Chaithanya.