Forum Discussion
Power Bi Report server don´t work
Hello. I'm having problems with my RLS. I'm configuring the rules in ssas and doing the direct query for power bi desktop. So far it works fine, the problem is when I deploy it to my company's Report Server, it doesn't work; the User can see everything.
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
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/
11 Replies
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/Hi experts,
I'm using the PB desktop to create any reports whare the source is a SSAS tabular model. I create all reports but now I nees apply the RLS.
then I publish on PBIRS
I used this tutorial: https://docs.microsoft.com/en-us/analysis-services/tutorial-tabular-1200/supplemental-lesson-impleme..., but the role does not work.
I created a little model to test, like this:
after that, I created the role and add my 3 members:
I connected another user to the Power bi desktop, and the rule was applied.
But When I run the report, we can see that each row appears 3 times, once for each member I include in my security table.
Anybody can help me, please?
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