Forum Discussion
Power BI Desktop Data Load Error
I receive two errors on tables I try to import. They appear in the Navigator window before I even have a chance to download the tables. Some of the tables import just fine and don't have these errors. They read:
Expression.Error: The column 'XXXXX.Value' of the table wasn't found.
Details:
XXXXX.Value
Where XXXXX is the name the table
OR
Expression.Error: The index is outside the bounds of the record.
Details:
Record=Record
Index=-1
Have you seen either of these before or know why they might be happening? I am importing my tables from an access file to a powerbi file, but I'm not sure that these errors are specific to Access.
I was building an Access database and connecting to it with PowerBI, just to make sure it worked. I kept getting the same "Index is Outside the Bounds" error. It appears my error (and maybe yours) is related to allowing multiple values in a lookup field. As soon as I disabled that, my error went away. I can connect to the Access DB no problem. Maybe this will help when someone else Googles it in the future...