Forum Discussion

tdipico's avatar
tdipico
New Member
7 years ago

Error loading tables with multiple value field/columns

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?

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi tdipico 

    I can't reproduce your problem.

    Could you show an simple example of your table?

    Did you do any other steps when importing data?

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • tdipico's avatar
      tdipico
      New Member

      Hi v-juanli-msft 

       

      is there any way I can send you the data that you can have a look at it

       

      Regards

      trdipico