Customers who want to consume Dynamics NAV data with OData in Microsoft Excel and have company names such as CRONUS A/G or CRONUS Danmark A/S may find it difficult or result in an error. When connecting to an OData feed from Excel, this does not work unless you don’t specify a Company Name in the connection string and set the company as a “Services Default Company” on the Dynamics NAV Server instance.
Tag Archives: ODATA
OData Performance Improvements In The June 2018 Power BI Desktop Release
In the June 2018 release of Power BI Desktop there were a number of improvements made to the way the Power Query engine handles OData data sources. You can read about them here:
Troubleshooting Data Refresh Performance Issues With OData Data Sources In Power BI And Excel Using Fiddler
A lot of people have problems with the performance of OData data sources when loading data into Power BI and Excel. One possible cause of these problems is query folding not taking place – if this is the case then the Power Query engine will be requesting more data that is needed and applying any filters itself locally, rather than requesting filtered data from the data source. How do you know whether query folding is taking place or not though?
Web Services Example 7 – Call NAV OData Web Services (Part 2)
This is the second part of a using NAV OData web services directly from C/AL code. First part can be found here. In that post it was demonstrated how to call NAV OData web services from C/AL code and read data without using any custom dll.
Web Services Example 7 – Call NAV OData Web Services (Part 1)
The Web Services series was started almost a year ago, after NAV Techdays 2015. All demos that I demonstrated have now been published. But I promised an extra example: call NAV OData web services directly from C/AL code. And at Directions EMEA 2016, a few weeks ago, I demonstrated that it is possible to call NAV OData web services from C/AL, without any custom dll, using .Net Framework library.
NAV ODATA Server Processing Error
Recently I was working with Dynamics NAV in the Web Services page of the RTC. I added some web services, deleted others and then also renamed some of them. No problem, I do that all the time, for demo purposes.
Viewing Page Data in Excel Using PowerPivot (OData)
Here I will discuss how you can use OData to expose a Microsoft Dynamics NAV 2015 page as a web service and then analyse the page data using Microsoft PowerPivot for Excel 2013. With OData and PowerPivot, you gain access to a powerful set of tools and technologies for data exchange and analysis.