Hello all,
I'm having trouble loading data in a table inside a solution in Dataverse. I'd be glad If someone could help me with this... I have attached a couple of screenshots below for your better understanding.
So basically I have an Excel file composed of 250ish rows that I want to migrate to the database inside my solution, my first attempt was to use the "Import data from Excel" button but it returned the following error.
As a workaround, I tried using dataflow with two methods:
1. Import from an Excel file and load data by mapping columns into my existing table (Dataflow using Excel)
2. Create a Dataverse table outside the solution from the Excel file in the database to then link Dataflow (Dataflow using Dataverse)
The problem is that with both methods I only get the first 50 and last 70 rows out of the 233 that I have - so I lose a lot of data in between and I don't quite understand why... as it worked in CASE 2 outside of the solution but in Dataverse... what could be trimming my data? Do you have any suggestions?
Thanks a lot for your time and attention!
