User unable to access semantic model

[Bhargava05]

My lakehouses are schema enabled and Onelake data access is enabled, i have just shared the lakehouse with an user with below permissions and also gave the user access through one lake data access to a schema and also granted permissions through sql end point to that particular schema.

Previously with above permissions user was able to create reports ,, explore data by using semantic model. Even he was able to access the data using excel, pbi desktop through all three ways lakehouse, sql endpoint, semantic model. This was working when tested before 2 weeks and doesnt seem to work now when followed the same process, the user now is getting the below error;

I also have tried creating another lakehouse with onelake data access enabled and shared the lh with build permissions still the same error.

Any suggestions are much appreciated! Thanks!!

[Bhargava05 · Accepted solution]

@v-prasare  thanks for your reply,

I aleady have given the user one lake data access to that specific schema and also i dont think you need to give wrokspace level permissions if the user only needs to build reports based on default semantic model right.

Please view this previous issue Solved: Re: OneLake data access - Microsoft Fabric Community, do you think this might the reason? as user was not able to preview the data from lakehouse even with one lake data access he was not able to do the same from semantic model? but however this was working for a while now and it only throwed the error for semantic model recently.

[v-prasare]

Hi @Bhargava05 , 

ensure that the user has the appropriate permissions set at both the workspace and OneLake levels. Specifically, the user needs to be assigned to a OneLake data access role that grants read permissions to the relevant folders within the lakehouse. This is in addition to any workspace-level permissions they may have.

For detailed guidance on configuring OneLake data access roles and understanding how OneLake security permissions interact with Fabric permissions, please refer to the following Microsoft documentation:​

https://learn.microsoft.com/en-us/fabric/onelake/security/data-access-control-model 

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[Bhargava05 · Accepted solution]

@v-prasare  thanks for your reply,

I aleady have given the user one lake data access to that specific schema and also i dont think you need to give wrokspace level permissions if the user only needs to build reports based on default semantic model right.

Please view this previous issue Solved: Re: OneLake data access - Microsoft Fabric Community, do you think this might the reason? as user was not able to preview the data from lakehouse even with one lake data access he was not able to do the same from semantic model? but however this was working for a while now and it only throwed the error for semantic model recently.

[v-prasare · Accepted solution]

Hi @Bhargava05 , 

According to the preview limitations of Lakehouse schemas, the SQL Analytics Endpoint and Semantic Model are among the functionalitites which are not supported in the current release of public preview:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query