When you use Power BI Desktop (or Power Query) to connect to a Dynamics NAV ODATA feed, the URL you pass looks like this: http://thinkaboutit:7048/NAV2016CU6/OData/Company(‘CRONUS%20BELGI%C3%8B%20NV’)/ where thinkaboutit is the server running your service tier, 7048 is the ODATA port and NAV2016CU6 is the Service Tier Instance. Company(‘CRONUS%20BELGI%C3%8B%20NV’)/ means that you are retrieving data from a Read More →

Today Microsoft announced Microsoft Dynamics 365 and Microsoft AppSource to bring our customers new, modern, enterprise-ready intelligent business apps. See this article here: Turning business process into business advantage for organizations everywhere. Dynamics 365 apps are designed so they can be easily and independently deployed. That means you can start small and pay only for Read More →

I have been asked this question a couple of times, during Power BI trainings and presentations. For some companies it’s important to know where exactly, in which country, data is stored. Well, in PowerBI.com, you can go to Help, About and find out: And voila, now you know 🙂

SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server. This release features: improved compatibility with Read More →

When entering data in Dynamics NAV, for example in a journal, time is sometimes lost on filtering or looking for the correct Customer, Item, Vendor, … Especially when using a dropdown (table relation). Yesterday I was at a customer site, and they told me that, for example, when entering customers or vendors in a journal, Read More →

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. But then, suddenly, when I tried to test a web service, by copy/pasting it’s URL Read More →

Yesterday I attended the Dutch Dynamics Community NAV event. It started with a very interesting keynote presentation by Vincent Nicolas about Engineering @Microsoft & Agile Software Development: After that there were 3 parallel sessions: NAV Performance Testing and Monitoring Tools David Worthington Test Automation Suite in Dynamics NAV 2016 Luc van Vugt PowerBI for Dynamics NAV Steven Read More →

A few days ago I received the following email from Microsoft: Needless to say I’m really honored and thankfull. I want to express thanks to everyone who helped me since a became involved in the NAV world, now about ten years ago. It’s been a fantastic ride… As a trainer and consultant, I have met Read More →