You’re offline. This is a read only version of the page.
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!
Hello Ahmed, It was in fact an issue related to data type differences - I was trying to import data with values outside of my predefined choices in some fields... I cleaned the wrong data and it worked!
Hello, @Anonymous, this could be related to data types, or format. Check this our to get more information about the failing records:
If my reply helped you, please give a 👍 If it solved your issue, please give a 👍 & accept it as the Solution to help other community members find it more.
Visit my Blog: ahmedsalih.blog
Visit my YouTube Channel: https://www.youtube.com/@powerplatformplace/videos
Microsoft Business Application MVP
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
