https://community.fabric.microsoft.com/t5/Data-Engineering/OneLake-data-access/m-p/4624419#M8197 <P>Hi</P><P>&nbsp;</P><P>I have a lakehouse which is schema enabled, OneLake data access enabled.</P><P>&nbsp;</P><P>Like suggested from microsoft documentation, i haven't added user to any of the workspace roles, i have just shared the lakehouse with no additional permissions. Now i deleted the default reader role and created a new role and assigned a user to the role.</P><P>&nbsp;</P><P>Now ideally the user should be able to see the data from lakehouse view, but it throws the below error</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bhargava05_0-1742916112578.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1253996iB2EA3752CA7CB908/image-size/medium?v=v2&amp;px=400" role="button" title="Bhargava05_0-1742916112578.png" alt="Bhargava05_0-1742916112578.png" /></span></P><P>We also did, multiple retries and also have tried back after almost 8 hours considering any latency.</P><P>But it gave the same error.</P><P>&nbsp;</P><P>In contrary, if im giving user viewer access to workspace, and then use onelake data access to restrict tables view, hes then able to view the data.</P><P>&nbsp;</P><P>If not for viewer role, user is not able to see the data in lakehouse view, but hes able to read the data using notebooks for only those tables given access to.</P><P>&nbsp;</P><P>And also if i try the user tries to read data using notebooks it throws the error, if given viewer role it executes successfully.</P><P>&nbsp;</P><P>Any suggestions or recommendations on how to deal with is much appreciated! Thanks.</P> Tue, 25 Mar 2025 19:13:13 GMT Bhargava05 2025-03-25T19:13:13Z https://community.fabric.microsoft.com/t5/Data-Engineering/OneLake-data-access/m-p/4624419#M8197 <P>Hi</P><P>&nbsp;</P><P>I have a lakehouse which is schema enabled, OneLake data access enabled.</P><P>&nbsp;</P><P>Like suggested from microsoft documentation, i haven't added user to any of the workspace roles, i have just shared the lakehouse with no additional permissions. Now i deleted the default reader role and created a new role and assigned a user to the role.</P><P>&nbsp;</P><P>Now ideally the user should be able to see the data from lakehouse view, but it throws the below error</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bhargava05_0-1742916112578.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1253996iB2EA3752CA7CB908/image-size/medium?v=v2&amp;px=400" role="button" title="Bhargava05_0-1742916112578.png" alt="Bhargava05_0-1742916112578.png" /></span></P><P>We also did, multiple retries and also have tried back after almost 8 hours considering any latency.</P><P>But it gave the same error.</P><P>&nbsp;</P><P>In contrary, if im giving user viewer access to workspace, and then use onelake data access to restrict tables view, hes then able to view the data.</P><P>&nbsp;</P><P>If not for viewer role, user is not able to see the data in lakehouse view, but hes able to read the data using notebooks for only those tables given access to.</P><P>&nbsp;</P><P>And also if i try the user tries to read data using notebooks it throws the error, if given viewer role it executes successfully.</P><P>&nbsp;</P><P>Any suggestions or recommendations on how to deal with is much appreciated! Thanks.</P> Tue, 25 Mar 2025 19:13:13 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/OneLake-data-access/m-p/4624419#M8197 Bhargava05 2025-03-25T19:13:13Z https://community.fabric.microsoft.com/t5/Data-Engineering/OneLake-data-access/m-p/4625491#M8216 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/744295">@Bhargava05</a>&nbsp;,</P> <P class="" data-start="88" data-end="151">Thank you for reaching out to the Microsoft Fabric Community.</P> <P class="" data-start="153" data-end="422">It appears that the OneLake Data Access feature is not functioning correctly for schema-enabled Lakehouses. I have tested this on my end and encountered the same issue. However, when using a Lakehouse without schema enabled, the feature works as expected.</P> <P class="" data-start="424" data-end="572">Since both the features (Lakehouse with schema enabled and Onelake Data Access feature) are currently in preview, this behavior may be a limitation of the preview phase.</P> <P class="" data-start="424" data-end="572"><A href="https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-schemas#public-preview-limitations" target="_blank">Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn</A></P> <P class="" data-start="574" data-end="761">You may find this related discussion helpful:<BR data-start="619" data-end="622" /><A href="https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-with-schema-preview-has-no-Manage-Onelake-data-access/m-p/4060023" target="_blank">Solved: Lakehouse with schema(preview) has no 'Manage Onel... - Microsoft Fabric Community</A></P> <P class="" data-start="574" data-end="761">&nbsp;</P> <P class="" data-start="763" data-end="914">If this post helps, please consider accepting it as a solution to assist other members in finding it more quickly. A kudos would also be appreciated!</P> <P class="" data-start="916" data-end="938">Regards,<BR data-start="928" data-end="931" />Vinay</P> <P>&nbsp;</P> Wed, 26 Mar 2025 08:59:53 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/OneLake-data-access/m-p/4625491#M8216 v-veshwara-msft 2025-03-26T08:59:53Z