Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ofcourse
Frequent Visitor

Unable to extract data from this visual. Please try again later.

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?

1 ACCEPTED SOLUTION
v-kongfanf-msft
Community Support
Community Support

Hi @ofcourse ,

 

Consider using the Viewer role in the Power BI workspace for users who need to view reports but should not have broader access rights. This role, combined with RLS, helps control access at a more granular level.
Also, make sure that RLS is properly configured in the Power BI Desktop file, and that the RLS rules are aligned with the permissions and roles defined in lonelake and Dataflow Gen2 to ensure consistent access control.

 

For more details, you can refer to below document:

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Roles in workspaces in Power BI - Power BI | Microsoft Learn

Access control lists in Azure Data Lake Storage Gen2 - Azure Storage | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

1 REPLY 1
v-kongfanf-msft
Community Support
Community Support

Hi @ofcourse ,

 

Consider using the Viewer role in the Power BI workspace for users who need to view reports but should not have broader access rights. This role, combined with RLS, helps control access at a more granular level.
Also, make sure that RLS is properly configured in the Power BI Desktop file, and that the RLS rules are aligned with the permissions and roles defined in lonelake and Dataflow Gen2 to ensure consistent access control.

 

For more details, you can refer to below document:

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Roles in workspaces in Power BI - Power BI | Microsoft Learn

Access control lists in Azure Data Lake Storage Gen2 - Azure Storage | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.