Forum Discussion

av_mikhailov's avatar
av_mikhailov
New Member
8 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I am having the same problem with Direct Query of MS SQL Server in Azure.

 

I am using SQL authentication. It works in Power BI desktop. After publishing, report shows the error (see below)

I have also updated published dataset with credential using Basic method with SQL authentication credentials.

 

I am not sure what have I missed here. Please help.

 

 

Here are the details.

 

Couldn't load the schema for the database model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please check the technical details for more information. If you contact support, please provide these details.
Underlying Error: A connection could not be made to the data source with the Name of '07fcf078-7916-4e68-8852-95a5577a3137'.  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.. The exception was raised by the IDbConnection interface.
Activity ID: 0df9a08b-9ea2-4f87-86b6-0a9e35709d04
Correlation ID: 3041412f-1eae-eb47-322b-e218a262a5e8
Request ID: 6a152610-a197-807e-07fe-9469afcf8185
Time: Wed Oct 24 2018 10:30:11 GMT-0700 (Pacific Daylight Time)
Version: 13.0.7220.114
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net

 

Venu_Sunkara's avatar
Venu_Sunkara
Helper I
6 years ago

Hi vikas2 ,

 

 im also getting the same issue, if you know the answer please get me out of this error.

 

im also using SQL DB in Azure and i provided my credentials as well.

 

Thanks is Advance.

 

Thanks,

Venu Sunkara

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello, 

     

     

    I also have the same issue using Direct Query on Azure SQL database.

     

    Does anyone find the solution please?

     

    Thanks