Forum Discussion
'Input string was not in a correct format' when importing using MySQL database connector
Hi, Micgig
Maybe it has something to do with the "Chengdu - Pmia" field in your table.
- + $ ( ) Display a literal character. To display a character other than one of those listed, precede it with a backslash () or enclose it in double quotation marks (" "). The most important thing is that the "-" is for characters in numeric format. You can try replacing this string before connecting.
Please refer to the following document for character formatting requirements.
https://docs.microsoft.com/power-bi/create-reports/desktop-custom-format-strings
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for replying.
One table, for testing purposes, literally consists of the following data (only 1 row).
| department_id | department_name | ts |
| 23 | Chengdu - Pmia | 202122110301001 |
I don't see particular formatting reasons why Power BI couldn't load this single row.
Yes the path is correct Alibaba cloud\AnalyticDB\MySQL instance.
What do you think?
Thanks!
Hi, Micgig
Maybe it has something to do with the "Chengdu - Pmia" field in your table.
| - + $ ( ) | Display a literal character. To display a character other than one of those listed, precede it with a backslash () or enclose it in double quotation marks (" "). |
The most important thing is that the "-" is for characters in numeric format. You can try replacing this string before connecting.
Please refer to the following document for character formatting requirements.
https://docs.microsoft.com/power-bi/create-reports/desktop-custom-format-strings
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.