A question I get asked sometimes, during my Power BI trainings is, can I use PowerPoint to display my Power BI reports and dashboards? Yes of course, I usually answer, and then I explain, that in your Power BI workspace, when you select your report, in the File menu there’s the following option: You simply … Read More →
Let’s get started. In Power BI Desktop, select Get Data, More: Authenticate using your Office 365 credentials (email & password), end then select a query: In this case, I’m filtering the navigator on queries that contain the word item in their name, and then I select Edit to verify the query in the query editor: … Read More →
Did you know that with Power BI you can connect to GitHub and create a stunning dashboard, like this one: Do you recognize it? It’s a dashboard about https://github.com/Microsoft/AL, which is the repo for developing extensions for Dynamics 365 “Tenerife” 🙂 How do I do this you might think? Well, it’s very easy, all you need … Read More →
Here’s a small teaser about the attendees for my workshop at NAV TechDays… Embed code Link you can send in email: https://app.powerbi.com/view?r=eyJrIjoiMzEzZjNlYWUtOWEyNy00MzQ2LWIxOWYtNDk0ZDQyMzQzMTk1IiwidCI6ImU1N2JmZjczLWY5YjQtNDliNS1hZWE1LWM2ZmRlNDFhYzljMiIsImMiOjh9 Link you can send in email: <iframe width=”933″ height=”700″ src=”https://app.powerbi.com/view?r=eyJrIjoiMzEzZjNlYWUtOWEyNy00MzQ2LWIxOWYtNDk0ZDQyMzQzMTk1IiwidCI6ImU1N2JmZjczLWY5YjQtNDliNS1hZWE1LWM2ZmRlNDFhYzljMiIsImMiOjh9″ frameborder=”0″ allowFullScreen=”true”></iframe>
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 →
Somewhere in mid 2017 Microsoft will release a new version of SQL Server in which we will have an integration with Power BI. This means we will (I hope) be able to use SSRS as an on premise solution to host Power BI reports, as you can read here on the SQL Server Reporting Services … Read More →
Watch this How Do I video to learn how to embed Power BI reports in Microsoft Dynamics NAV 2017. The demonstration covers the following steps: how to authorize the application selecting reports report navigation sharing reports Learn more at http://aka.ms/NAVGetReady
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 →
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 had the honor of presenting a webinar about Power BI and Microsoft Dynamics NAV.
https://www.youtube.com/watch?v=u_nWPvBkU9w
The recording has been uploaded and is available here. Enjoy 😉
And, of course, I would like to thank Mark Brummel for inviting me for this webinar!
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 →
Get an overview of the exciting new features and tools available for Microsoft Power BI: live dashboards, interactive visual reports, the Power BI Designer and mobile apps: