ole db or odbc error: 0x80040. on multiple reports

[AlexanderAT]

Hello forum

Yesterday I got these errors on multiple reports referring to different databases, all from MySQL, when refreshing on the desktop version. 

I have tried all the suggestions I have found on the forum, change settings in global and current data load settings, remove and sort dates in multiple ways. The only conversion I have in my SQL query in converting unixtime to date, and this has not coursed problems before. Any help is much appreciated

Link to pbix file: https://drive.google.com/file/d/1iC_wb64awmUHHsxwhonTJ0d3tj3tkm7N/view?usp=sharing

[v-cherch-msft]

Hi @AlexanderAT

In Power BI Desktop, we can enable tracing log via File –> Options –> Diagnostics –> Enable Tracing. When we meet the error when use Power BI desktop, we can go to check detail information. Please take a look at links below:

Power BI Desktop Trace Logs Analyser

If you need further help, you may submit a support ticket.
https://powerbi.microsoft.com/en-us/support/

Regards,

Cherie