It is now possible to subscribe to a report to receive an email with a snapshot of that page to your inbox. You will receive an email snapshot of each report page when the report is refreshed. If the report doesn’t refresh, you will not receive a snapshot email that day. If the report refreshes more 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 →

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 🙂

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 →

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 →

Microsoft has made the new Power BI preview available for everyone. If you go here: https://www.powerbi.com you can create your free account to test out the new features of Power BI. Here you can download the Power BI Designer: https://www.powerbi.com/dashboards/downloads/designer so you can get started to create your own Power BI reports. Have a look here to Read More →