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
Exported PDF from PowerBI to not have any indents/borders
Currently, using the "Export to PDF" option in PowerBI results in two consistently buggy results: A white border/indent is generated, increasing the size of the page from 8.5x11 to 9x11.5 Sometime...EliShalev1 hour agoNew MemberNew3Views0likes0CommentsAdding a Container for Logical Grouping of Activities in Data Pipelines
Dear Team, I would like to propose a feature enhancement for Data Pipelines in Microsoft Fabric that allows the logical grouping of activities into a container. This container would serve to: Im...lukas_karlovsky2 hours agoNew MemberPlanned868Views15likes5CommentsSupport Native SQL LIKE / NOT LIKE Wildcard Filtering Across Power BI Reports
Description Currently, Power BI does not provide a native way for report consumers to perform dynamic SQL-style wildcard filtering using patterns such as LIKE '____' - Above return all values wit...Seeralan4 hours agoNew MemberNew4Views0likes0Comments