Forum Discussion
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...
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
Microsoft Employee
Microsoft Employeengkim 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?