Forum Discussion
Power BI Desktop Data Load Error
amtanner This is new feature introduced with power bi desktop latest update. It notifies you of any errors during import. You can choose to look at them and figure out what went wrong or simply ignore it. It doesn't mean error in the process of importing but error in the actual data and so it depends on how critical it is for you to have 100% clean data.
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...