Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
12angrymentiger
Advocate III
Advocate III

One Table is erroring out (while parsing data) when I try to query it in the SQL Analytics end point

We have one table which I can see in the lakehouse but cannot view/query in the sql end point.
 
It's failing on the EndDate field which is a datetime.
 
Error:
Msg 19780, Level 16, State 1, Line 1
Error encountered while parsing data: 'Inserting value to batch for column EndDate failed with unexpected error'. Underlying data description: table '......', file '.................'.
2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

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.

View solution in original post

Hi @Anonymous  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

View solution in original post

5 REPLIES 5
12angrymentiger
Advocate III
Advocate III

Hi @Anonymous  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).

Anonymous
Not applicable

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.

Hi @Anonymous  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

Anonymous
Not applicable

Hi @12angrymentiger 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

Anonymous
Not applicable

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

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.