Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.