I hit this error almost everytime I try to automate a datadump and one of the fields may have a different data type than expected.
Need to automatically detect data types, but also help user pinpoint which column is throwing the error and is mismatched.
I have sheets with many columns and it is very tedious to figure out which one is causing the issue.
Error returned: 'OLE DB or ODBC error: [Expression Error] The key didn't match any rows in the table
No CommentsBe the first to comment
Recent ideas
Support Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull221 hour agoAdvocate INew2Views0likes0CommentsImprove Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv1 hour agoMicrosoft EmployeeNew12Views4likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db2 hours agoNew MemberNew223Views2likes1CommentTenant and/or App/Workspace Banner messages- alerts
As a tenant admin - would like to publish banner messages or alerts as needed for the organization in the event of a data load failure, or other messaging that needs to be show to the end user on l...sue_yerly2 hours agoNew MemberNew378Views18likes3Comments