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 →

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 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 →

If you upgrade to Microsoft Office 2016, which I highly recommend, you will notice that ‘the Power’ has disappeared. With Power I mean, Power Pivot, Power View, Power Query and Power Map. So where did they go and how can I get them back? Actually, they’re not gone, let’s have a closer look. First you Read More →