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 any else user. Report returns the error:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface
Artem
13 Replies
That is the classic problem known as Kerberos Double Hop.
Please ask to your AD administrator to set the right SPNs for your SSRS and allow delegation between the SSRS and SQL Server.
This is not a problem of the Power BI :)
Hi all,
I have Power BI report that use DirectQuery to MSSQL 2016 database on a view
Locallly the report works fine
Remotely I get the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface"
Please help
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.
