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

Hi Ermal 

You need to open Power Query and detect what row is causing the error. it should tel you.

 

Ermal's avatar
Ermal
Frequent Visitor
2 years ago

Hi aj1973,

 

Thanks for the reply. How do I detect that?

 

regards,

Ermal

  • 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?