Forum Discussion
DirectQuery Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Hi all, I have Power BI report with DirectQuery to MS SQL 2016 database. Report works locally on Power BI Server, and works remotely in Chrome in my admin credentials But report don't work on...
Ahh, I forgot something. You can workarround this problem if you set an user name and password on the report datasource, instead of the default Windows Authentication.
Tnx, but only Windows authentification is acceptable for my case
Hello, I have the same error when I use Chrome.
It works when I use IE.
I tried to import settings from IE but I still have the same error.
It's typical Kerberos issue. AUTHORITY\ANONYMOUS LOGON. Can you just use the sql login while connecting to data source or you should enable Kerberos in order to cover double-hop scenario.Adam made a nice video which explains Kerberos configuration - https://guyinacube.com/2017/02/configure-kerberos-power-bi-reports-reporting-services/
