I am trying to load data to Power BI Desktop from an Access database. When a table in a column in that database contains a multi value fields that are selected from a drop list, 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 'ReceivingTanksFilled.Value' of the table wasn't found.
Details:
ReceivingTanksFilled.Value
or
The information uploads and the column does not appear in Power BI Desktop.
I have two tables, one table contains the list of tanks that need to be selected where the product received is going to be filled with just the Tank Names. The MaterailsReceiving contains the columns: ID, fldDate, ProductName, VolumeRecieved, ReceivingTanksFilled.
.
The first error relates to the MaterialsReceiving table, the second error relates to the Tanks Table
I think that if the first error gets solved the second error also gets solved automaticaly.
How can I resolve these errors and be able to load the data?
