Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, everyone.
I've run into an error while trying to connect to the "work_time" table in our company's database:
DataSource.Error: ODBC: ERROR [22007] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.28-0ubuntu0.20.04.3]Invalid time(hours) format. Use interval types instead
Here's the screenshot of table's structure:
I didn't happen to find any workaround. Anyone had the same issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @razmochaev,
According to the error message, it should be something related to date type or date/time format. And it’s very likely that it’s work_date, time_from or time_to columns cause this issue. Set work_date as date data type and set time_from/time_to time data type should be proper. For the date/time types supported in Power BI, Please refer to this official doc Data types in Power BI Desktop - Power BI | Microsoft Docs.
Best Regards,
Community Support Team _ Caiyun