Forum Discussion
OData Query error from NAV2016
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
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
Best Regards
Maggie
2 Replies
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
Best Regards
Maggie
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
