The exception was raised by the IDbConnection interface

hi rmh 

According to the error message, it sound like related to azure credentials. Have you enabled MFA on your data source? If this is a case, I'd like to suggest you take a look at following links about ADFS and AAD auth error:

Configure Azure Multi-Factor Authentication Server to work with AD FS in Windows Server 

AAD Auth Error - Login failed for user '<token-identified principal>' Part 2 

Regards,

Lin

Thanks for articles, but no, I am not using "Azure Active Directory - universal with MFA". I am using "SQL Server Authentication". Any other tips?

And by the way, this error appears only after I publish the report. So I do not have this problem in the report befor publish.  

hi  rmh 

Please check if you have set “report viewers can….” as below:

Regards,

Lin

could you please let me know where to find the setting you show in your comment? I have looked here and can not find the setting you refer to. 

hi  rmh 

When you edit data source credentials in the dataset setting. It seems that data source credentials is not available in your screenshot?

Regards,

Lin

ok, I can see. I try to find out. Thanks

Hello guys,

I have the same issue

https://community.powerbi.com/t5/Service/Visual-error-in-DQ-amp-Live-Connect-Login-failed-for-user-lt/m-p/2165454#M143593

The connection with Direct Query to the Azure SQL Database server does not work in Power BI Service, even though the user credential in dataset settings works.

Thanks.