Forum Discussion
Error when loading tables with foreign keys
I ma trying to connect Power BI to a localhost MySQL database. When a table in that database contains a foreign key I get the following errors when i want to load the data: Expression.Error: The ind...
It took a while but I finally found the problem.
Apparently Power BI doesn't like it when you use capital letters in your column name.
So I change employeeNumber to employee_number and no more errors.
It took a while but I finally found the problem.
Apparently Power BI doesn't like it when you use capital letters in your column name.
So I change employeeNumber to employee_number and no more errors.