Forum Discussion
Error happened while reading data from mysql to Power BI
When connecting MySQL data to Power BI, the data loads successfully in Power Query. However, upon clicking 'Close & Apply,' an error message appears: 'An error occurred while reading data from MySQL ...
this error might indicate an issue with the data type or format of the data being loaded or it might be because of COALESCE(CAST(ROUND(order_value, 2) AS DECIMAL(10,2)), 0.0) also.
I've tried several methods, but I still can't get it to load after clicking 'Close & Apply.