Have you heard of Microsoft Flow? No, well then please have a look here: https://flow.microsoft.com You can use it to create automated workflows between apps and services to get notifications, synchronize files, collect data, and more. So, in the context of let’s say Power BI, you can use Flow to synchronize data sources. In this blog … Read More →
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 →
This video demonstrates how to use CAL query objects to create nested loops in Microsoft Dynamics NAV. … Read More →
This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct? Create the Query Add more information Select Distinct with Queries in Microsoft Dynamics NAV on Vimeo
This video demonstrates how to implement the activity log pattern in Microsoft Dynamic NAV. The demonstration covers the following steps:
– Record the Activity
– One Centralized View
– Present to the User … Read More →
Recently someone asked me how to print barcodes in a Dynamics NAV RDLC report. And I hade done something similar, years ago in NAV2009. So I had a look at my code and updated it to NAV 2015. As you can see, it still works: Usually a barcode is no more then a font you … 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 →
Recently I stumbled upon this blog: http://blogs.msdn.com/b/powerbi/archive/2015/12/18/3-twitter-kpis-to-share-on-your-business-dashboard.aspx It shows how you can export your Twitter analytics and use it as a source in a Power BI Dashboard: The process is very simple. Get Your Twitter Data Go to analytics.twitter.com. You may have to log in to your Twitter account. Click on Tweets in the Twitter … Read More →
In this video I explained how to setup and configure the PowerBI.com Content Package for Microsoft Dynamics NAV 2016. Since then I have received a lot of feedback and questions from the community on how to get it to work with a local NAV 2016 instance. Well, imagine that you have NAV 2016 running on … Read More →
Microsoft Dynamics NAV 2016 has been released, as you might have noticed on many MVP-blogs and on the Microsoft Azure platform there’s now also a Dynamics NAV 2016 template available in the gallery: It contains NAV 2016 pre-installed, which you will find in the menu under D: In the C:\DEMO folder you will find setup … Read More →
This video demonstrates how to create links in report in Microsoft Dynamics NAV 2015.
I’m very excited to announce the coming release of my new book: Microsoft Dynamics NAV 2015 Professional Reporting. Because of the success of Microsoft Dynamics NAV 2009: Professional Reporting, I was asked to create an update towards Dynamics NAV 2015. I gently declined this request and proposed instead to completely rewrite the book. The reason was simple. … Read More →
Dynamics NAV is full of features to make life easier for users and developers. One of these little gems is the F2 key. In the help about this shortcut it simply says: Edit. But did you know that is has some undocumented features as-well? In the Dynamics NAV application: When you navigate to a field, … Read More →