ODATA – Page 2 – Pardaan.com

How to get OData URLs with company names that contain forward slashes

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…

2 October 2018

Data & Analysis

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: Bron : Chris Webb's BI Blog Lees meer...

3 July 2018

Data & Analysis

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…

10 May 2018

Dynamics NAV & BC Tips & tricks

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.…

14 December 2016

Dynamics NAV & BC Tips & tricks

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…

31 October 2016

Dynamics NAV & BC Tips & tricks

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. Bron : Think about IT Lees…

20 January 2016

Dynamics NAV & BC Tips & tricks

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…

28 August 2015