The exception was raised by the IDbConnection interface

[rmh]

Hi, the message here says that the visualisation can not be read/loaded, try later or approach support, and give the following info to the support. My question is which suport are we talking about here? Is it this forum or some whare else. The error occurs after I publish the powerbi report. I do not know what the cause and what is missing. Please advise. 

[v-lili6-msft]

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

[rmh]

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.  

[v-lili6-msft]

hi  @rmh 

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

Regards,

Lin

[rmh]

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. 

[v-lili6-msft]

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

[rmh]

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

[thhmez7]

Hello guys,

I have the same issue

https://community.powerbi.com/t5/Service/Visual-error-in-DQ-amp-Live-Connect-Login-failed-for-user-l...

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.