Error happened while reading data from mysql to Power BI

Hi Yunus_Miah ,

1. You seem to have defined two order_type aliases.

2. One possible problem is that in some cases, the order_created_at, delivered_date, and reconciled_at fields may be non-date-type values (e.g., strings or numeric values), which can cause CAST operations to fail. In addition, if some of the values in these fields cannot be converted to a valid DATE type, then the DATE function will also fail.

You attempted to convert dms_order_id, sku_id, group_order_id, DB_id, dsr_id, retailer_id, and vaccount_id to the UNSIGNED type. If the original field is not an integer type or contains a value that cannot be converted to an unsigned integer (such as a negative or null value), this may result in the error.

You can try querying one field at a time to narrow down the problem.

You can also run the SQL query directly in a MySQL environment to see if it executes successfully or if there are more detailed error messages.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum