Good morning
I created a dashboard on PowerBI desktop and published it to the power bi service in microsoft fabric to allow users to access it. The power bi report connects to the lakehouse in directquery mode. The lakehouse contains processed data coming from dataflow gen2.
My problem is that once published, when I define the roles and access through "audience" or through RLS, I get the following error: "Unable to extract data from this visual element. Please try again later. Try again later or contact support. If you contact support, provide this information."
I noticed that to allow the user to have access to the report data, they must add a "Reader" role in the workspace but I do not want users to have access to all the components fabric (Dataflow, notebook, semantic model, etc.) which is located in this workspace.
I tried to assign access to the lakehouse, the sql endpoint or even the semantic model but I still get this error.
My workspace uses purchased fabric capacity and my reporting is based on a semantic model of a lakehouse.
Do I need to connect my workspace to Azure Data Lake Gen2 Storage to manage authorizations or is there another possibility?
