Error viewing content of Direct Lake table

[chad_clift]

We have a report that is built from a semantic model connected to data within a Lakehouse using Direct Lake mode. Until recently, users were able to view the content once we shared the report with them along with granting Read All permissions to the Lakehouse. Now they are getting the below error and it seems the only resolution is potentially to grant them Viewer access to the workspace. We don't want to grant viewer access to the workspace. Is there a way to allow them to view the content of the specific report?

[chad_clift · Accepted solution]

Found the solution...  My cloud connection on the semantic model was set to SQLServer when it needs to be AzureDataLakeStorage

[tayloramy]

Hi @chad_clift, 

Granting readall should be enough to allow users to view the reports. 

I've noticed sometimes it takes a while for permissions to propagate, if you wait a while and the issue is still there, I'd recommend opening a ticket to Microsoft, this is unintended behaviour and I suspect something is broken. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[chad_clift]

That was enough to allow them to view reports last week.  Wondering if something changed that would require different permissions now. 

[tayloramy]

Hi @chad_clift, 

I'm not seeing anything with the september update that would indicate this. Fabric September 2025 Feature Summary | Microsoft Fabric Blog | Microsoft Fabric

I'm also not able to replicate this in my enviornment, it is working as expected for me. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.