OLE DB or ODBC error

[Ermal]

Getting constantly below error.

Can someone please help?

Errors pops up when I filter all the zero's away in a specific column.

Thanks!

[aj1973]

Hi @Ermal 

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

[Ermal]

Hi @aj1973,

Thanks for the reply. How do I detect that?

regards,

Ermal

[aj1973]

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

[lbendlin]

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?