Row level Security in Power BI

[Chayan]

I have created RLS in Powerbi and have provided restricted access to users. Users are sometimes( not regularly) getting error as 'couldn't load the data for this visual'. What might be the reason and how to rectify this.

[v-cgao-msft]

Hi @Chayan ,

1. Are the errors occurring with specific visuals or across multiple visuals? 
If there is an error with a single visual, you can test the visual on your desktop to determine if it is rendering correctly.
You can check the performance of the visual's query in the Performance Analyzer. You can also copy the visual's DAX query in the Performance Analyzer.Paste it into the Dax query view to execute it and check if it returns results other than expected.
Use Performance Analyzer to examine report element performance in Power BI Desktop

2. Click on “Details”, what information is in there?

You can also use Dianna's suggestion to run further tests to determine the cause of the problem.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[diana658]

---

@ChayanFloridaBlue wrote:

I have created RLS in Powerbi and have provided restricted access to users. Users are sometimes( not regularly) getting error as 'couldn't load the data for this visual'. What might be the reason and how to rectify this.

---

Hello, @ChayanFloridaBlue 

The intermittent error ‘couldn’t load the data for this visual’ in Power BI when using Row-Level Security (RLS) could be due to several reasons. Here are some potential causes and solutions:

Data Refresh Issues: Ensure that the dataset is refreshing properly. If there’s a scheduled refresh, check if it’s completing successfully.
Complex Measures or Calculations: If you have complex measures, they might be causing the issue. Simplify the measures or break them down into smaller parts.
Date Format in Measures: Incorrect date formats in DAX formulas can cause errors. Ensure that date formats are consistent and correct.
DirectQuery Performance: If you’re using DirectQuery, the error might occur due to large volumes of data. Consider filtering or aggregating data before loading it into Power BI.
RLS Configuration: Verify that RLS is configured correctly and that users have the appropriate roles assigned to them. Admins and dataset owners can see all records even if they don’t have RLS roles, which might not be the case for other users.
Power Query Issues: Check all queries in Power Query to ensure they load without authentication errors. Reconfigure connections and credentials if necessary.

I hope this step is helpful to you.

Best Regard,
Dianna Hill