- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
One Table is erroring out (while parsing data) when I try to query it in the SQL Analytics end point
Error encountered while parsing data: 'Inserting value to batch for column EndDate failed with unexpected error'. Underlying data description: table '......', file '.................'.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @12angrymentiger
There might be an issue with a value in the EndDate column. Please review the data values, especially if you have other datetime columns working like StartDate.
Hope this helps. Please let me know if you have any further questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-nikhilan-msft I was able to fix this issue by setting the EndDate column as a StringType(). I also had to do the same thing with another date field which is weird as the data looks fine.
I'm now able to query the table in the sql endpoint.
Thanks again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-nikhilan-msft I'm creating a landing/bronze/silver table and then a merge to gold just like all 50+ other tables I have.
This is the only table that is having a problem querying and it appears to be on one field only (EndDate).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @12angrymentiger
There might be an issue with a value in the EndDate column. Please review the data values, especially if you have other datetime columns working like StartDate.
Hope this helps. Please let me know if you have any further questions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @v-nikhilan-msft I was able to fix this issue by setting the EndDate column as a StringType(). I also had to do the same thing with another date field which is weird as the data looks fine.
I'm now able to query the table in the sql endpoint.
Thanks again
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @12angrymentiger
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @12angrymentiger
Thanks for using Fabric Community.
Apologies for the issue you have been facing. Can you please provide the repro steps taken to get to that point? This would help me in understanding the issue better.
Thanks
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
12-17-2024 08:02 AM | |||
11-20-2023 10:50 PM | |||
09-30-2024 01:17 AM | |||
05-07-2024 10:07 AM | |||
08-07-2024 04:26 AM |
User | Count |
---|---|
10 | |
6 | |
2 | |
2 | |
1 |
User | Count |
---|---|
13 | |
12 | |
6 | |
5 | |
4 |