cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlexandruNBD
Regular Visitor

Power BI new created user can not see data in report server while all other users can

I am trying to test how row level security works. I have a live connection between Power BI and my data model in SSAS.

In order to test the row level security I have created a new user. I followed the row level security tutorial on the MS website but kept having trouble because when i logged in with the user in Report Server i could not see any data. All I could see was the blank table.

However, what I realised was that even if i didn't put any row filters or even if I assigned the user as admin it still could not see any data.

Here is what I see when i login with this test user (even though they now have an admin role and should see all the data):

Capture.PNG

 

Would anyone be able to assist with this? When I login with my own user in report server I can see all the data fine.

 

Would really appreciate the help.

2 REPLIES 2
KBO
Super User I
Super User I

Hi @AlexandruNBD ,

in this case you put the RLS into the SSAS and you can test it directly in SSAS 🙂

here are some helpful links:

https://radacad.com/row-level-security-with-ssas-tabular-live-connection-in-power-bi

https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=49

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

vkarumanchi
Helper I
Helper I

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors