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
Parameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v1 hour agoCommunity ChampionNew7Views0likes0CommentsAutomatically match PowerBI chart background color to Powerpoint slide background color
Export PowerBI to PowerPoint slide - Can we define the PowerBI export background color to automatically match the PowerPoint slide background color ? By Default, the PowerBI background color is Whi...jim_chan6 hours agoNew MemberNew7Views0likes0CommentsNew Card Visual - Alignment of Reference Label Values
The latest Power BI Desktop version I'm allowed to use at work currently is Version 2.154.1260.0 (May 2026), so if this request has already been implemented in later versions, please disregard. Othe...nk685f6 hours agoAdvocate INew9Views0likes0CommentsSupport QR codes in the barcode scanner in the Power BI app
I was surprised to find that the barcode scanner inside of a Power BI report in the mobile app only supports scanning barcodes, not QR codes. Our warehouse uses QR codes everywhere, so I cannot use t...Jaap_O_RFH14 hours agoNew MemberNew15Views0likes0Comments