Cannot open server "work" requested by the login. The login failed.. The exception was raised by

[Anonymous]

Hi,

I have an issue with visuals from direct query. Seems like most of the fail with the error message: "Cannot open server "backe.no" requested by the login. The login failed.. The exception was raised by the IDbConnection interface."
I tried changing one table from Direct Query to Import mode and it worked just fine. 
Any ideas on what's wrong or what I can do?

Thanks!

[v-jingzhang]

Hi @Anonymous 

Do you still see this error message? Do the links Amit provided help to solve it?

Best Regards,
Community Support Team _ Jing

[amitchandak · Accepted solution]

@Anonymous , Please check two related issue , if there responses can help , else create a new one

https://community.powerbi.com/t5/Issues/The-exception-was-raised-by-the-IDbConnection-interface/idi-p/1553193

https://community.powerbi.com/t5/Issues/Direct-Query-issues/idi-p/836711/page/2

also check

https://docs.microsoft.com/en-us/answers/questions/102295/idbconnection-error-on-process-sass-database-cause.html