Forum Discussion

Steffe's avatar
Steffe
Helper I
5 years ago

Oct 2020 - Direct Query SQL problem

Hi,   We have a problem with reports using DirectQuery against SQL Server. This seems to arrived after we upgraded to october 2020 version of Power BI Report Server and Desktop. It works if you us...
Direct Query
Erikvan_D's avatar
Erikvan_D
Frequent Visitor
5 years ago

We have exactly the same bug except that we use basic authentication. The exact same error occurs while the connection itself tests succesful under "Manage data sources". I also noticed the difference in the connection string but no way to alter it on the server side. The strange thing is that sometimes it works, but the next day the same, untouched, report does not work anymore. In the past this worked flawlessly.

Downgrading to May is not an option for our organisation. 

  • Steffe's avatar
    Steffe
    Helper I
    5 years ago

    Thanks for the reply Erikvan_D .

    "Good" to know that this isn´t something that only appears at our server.

    Would be nice to know if Micorsoft is working on this bug and if we can expect a fix soon?