Forum Discussion

sgovindarajula's avatar
sgovindarajula
Frequent Visitor
8 years ago

Direct Query report is breaking in Report Server October Version

Hi There....   We have built Power BI Report by connecting to SQL Server with Direct Query mode. When we published to Report Server, the report broke and it is not working.  We tried to change the...
DirectQuery
Report Server
sql server
Mikkelnaes's avatar
Mikkelnaes
Helper I
8 years ago

Same here, is there any solution yet?

 

thanks

irvmic's avatar
irvmic
Frequent Visitor
8 years ago

Are you using logged in user or a fixed user for the direct query?

 

If it is set "As the user viewing the report" you have to make sure that it works to pass the credentials.

 

Have you tried test the connection on the manage screen? And if so does it work there. If not then you might get a better error message there.

 

If you get this message:

"Couldn't connect

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details 

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

"

Then it means you are not passing credentials correctly. I get  this problem in Chrome on my computer but Edge and IE works.

  • sgovindarajula's avatar
    sgovindarajula
    Frequent Visitor
    8 years ago

    Hi,

     

    We are using logged in user for the direct query. And once we publish it to report server, we don't have option to impersonate the user. The entire data sources tab under Manage Report is greyed out.

     

    Thanks

    -S