cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SftStag Frequent Visitor
Frequent Visitor

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 index is outside the bounds of the record.

Details:

Record=Record

Index=-1

 

and

 

Expression.Error: The column 'employeenumber' of the table wasn't found.
Details:
employeenumber

 

I have two tables, orders and employees. The orders table contains the columns: ID, ProductName, Price, Employeenumber

The employees table contains the columns: Employeenumber, firstName, lastName.

orders.employeenumber is a foreign key of employees.employeenumber.

The first error relates to the employees table, the second error relates to the orders table.

I think that if the first error gets solved the second error also gets solved automaticaly.

 

When i remove the foreign key from the talbe the data loads normaly.

 

How can i resolve these errors and still keep the foreign keys?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted