Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Solved! Go to Solution.
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 @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
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).
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 @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
Hi @12angrymentiger
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
4 | |
2 | |
1 | |
1 | |
1 |