Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
is there any way I can send you the data that you can have a look at it
Regards
trdipico
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |