Forum Discussion

Ermal's avatar
Ermal
Frequent Visitor
2 years ago

OLE DB or ODBC error

Getting constantly below error. Can someone please help? Errors pops up when I filter all the zero's away in a specific column. Thanks!    
Need Help
aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

In power Query follow the steps applied to see when the error happened 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Sometimes when you load your data to Power BI it will tell you x rows, y errors.  You can click on "show errors"  and then Power Query will run another copy of your query but only "keep error rows".  That will allow you to quickly identify the offending column.

 

Are you sure this is not an issue on the HANA side?