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

It sounds like you are still having the same issues with the "Key not present" errors.  Let's start at the beginning.  Can you check the database that you are accessing and make sure that the account you are logged in as, and the account that is running PowerBI both have READ access to the tables and columns?  Not familiar with that database, but this is where I would start, since the script syntax is correct.

ngkim's avatar
ngkim
Regular Visitor
10 years ago

Dear Nhallquist

 

Thank you for your reply.

I am always logging in database with root account, and Power BI can read all the tables as you can see below.

 

 

As my earlier post, I can get the data from the first 3 tables only.

 

 

  • pqian's avatar
    pqian
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    ngkim this doesn't make any sense...

     

    If you delete everything and just leave this step:

    Source = MySQL.Database("localhost", "db_energy", [ReturnSingleDatabase=true])

     

    You see the base navigation table right? Next, if you click on the link inside the table, what happens?

     

    is db_energy your database name AND your schema name?