Forum Discussion

ngkim's avatar
ngkim
Regular Visitor
10 years ago

2 Errors: Unknown column and Key not present in dictionary

  Hello.   I am trying to connect to my local database. It's MariaDB 10.1.9. Connection is always successful but I can get the data from only 1 table. And I get permanently 2 types of errors fro...
Need Help
Show and Tell
Nhallquist's avatar
Nhallquist
Icon for Helper V rankHelper V
10 years ago

"What is the column name that is represented in Error Type 1?  The error shows"$Ordered.?_????".  Maybe there is a character that is not recognized in the column name?  Try renaming that column, and then see if that clears you other error.

ngkim's avatar
ngkim
Regular Visitor
10 years ago

Dear Nhallquist

 

Thank you for your reply, it partially solved my problem.

 

I have changed all field names of 2 tables (interest rates and currency rates) into English as your advice.

(All other tables' fields are in English already)

 

And then Power BI successfully got the data from interest rates table.

But about currency rates table, it gets a new error as below.

 

<New error from a table where originally I got "Unknown Column" error>

DataSource.Error: Non-negative number required.
Parameter name: count
Details:
DataSourceKind=MySql
DataSourcePath=localhost;db_energy

 

I suspect it's because this table has 2 text fields in Korean.

Field Names: `DataSource`, `DataQuality`

And all data of these 2 fields are "Bank of Korea", "OFFICIAL(NATIONAL)" (written in Korean)

 

I will retry after deleting these 2 fields and then see what happens.

Thank you again and I will report you what happens.