Forum Discussion
Power Bi Report server don´t work
- 4 years ago
I believe I answered this in your other question here https://community.powerbi.com/t5/Report-Server/RLS-using-SSAS-tabluar-model-doesn-t-work-in-PBIRS/m-p/2377163#M23181
- 4 years ago
Anonymous wrote:
I put the other option and I have the following errorAn unexpected error occurred
An unexpected error has occurred. Try again later.
Please try again later or contact support. If you contact support, please provide these details.Is your SSAS instance on a different server to PBIRS? If so have you configured Kerberos authentication?
If you have not configured this you need to do this in order for RLS to work - see https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports
If you have configured Kerberos and it was working previously you could be hitting this issue
https://darren.gosbell.com/2021/11/power-bi-report-server-an-unexpected-error-occurred-nov-2021/
Anonymous wrote:
in credentials I selected windows authentication,
afther i selected user the following credentials and put the credentials that have Admin privilege in ssas
So that is your issue. SSAS sees everyone as being that one admin user and gives everyone access to all the data.
If you are using RLS you should ALWAYS use the "current user" setting so that people get the correct role applied by the SSAS server.
An unexpected error occurred
An unexpected error has occurred. Try again later.
Please try again later or contact support. If you contact support, please provide these details.