topic Re: Power BI new created user can not see data in report server while all other users can in Report Server

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

Anonymous — Wed, 22 May 2019 06:52:45 GMT

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):

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.

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

vkarumanchi — Mon, 10 Aug 2020 12:17:36 GMT

hi @AlexandruNBD,

Please check if he has the access to this to this report:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

https://radacad.com/dashboard-sharing-and-manage-permissions-in-power-bi-simple-but-useful

Regards,

Vara

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

KBO — Mon, 10 Aug 2020 12:57:02 GMT

Hi Anonymous ,

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!