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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rajivkaushik
Regular Visitor

The report can't be viewed because the underlying dataset uses row-level security(RLS)

I have started getting this error "The report can't be viewed because the underlying dataset uses row-level security(RLS)" while accessing dataset in Power BI through SSAS Tabular live connection. It was working fine and nothing has changed except updating the gateway. Any idea how to fix it?

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

Hi @rajivkaushik,

I think you need to do 'UPN' on your data source to mapping current users with the underlying database roles.

Please take a look at the following link to know more about these:

Manage your data source - Analysis Services#user-names-with-analysis-services 

Implement row-level security in an on-premises Analysis Services tabular model 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @rajivkaushik,

I think you need to do 'UPN' on your data source to mapping current users with the underlying database roles.

Please take a look at the following link to know more about these:

Manage your data source - Analysis Services#user-names-with-analysis-services 

Implement row-level security in an on-premises Analysis Services tabular model 
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors