OData Query error from NAV2016

[MartinSuryadi]

Hi everyone,

I am pulling OData from our on-premise NAV Service and this is the error I got from one of our database.

It seems there is an error during deployment of NAV as we do not use this field in the system.

 

Is there a way I can "filter" out this column before downloading? I have "removed" these columns but the error still stays. I have tried to filter dates by setting RangeStart and RangeEnd however it seems to dowload the entire data before applying the filter

Best Regards,

Martin

[v-juanli-msft · Accepted solution]

Hi @MartinSuryadi 

Please ensure you follow the correct step in Power BI to connect to NAV.

https://docs.microsoft.com/en-us/dynamics-nav-app/across-how-use-financials-data-source-powerbi

Then check if there is any problem on NAV side.

https://forum.mibuso.com/discussion/35889/changing-vat-amount-on-f9-statistics-window

https://docs.microsoft.com/en-us/archive/blogs/nav_developer/nav-2009-web-services-on-a-three-machin...

Best Regards

Maggie

[MartinSuryadi]

Thanks, will try to check the NAV side. It seems that when we query too many tables the SQL may occassionally timeout...

I think.. The "error" message kinda indicate the point where the timeout stopped