Power BI

Last week, I had published a Power BI contest where you had to solve some clues to unlock a hidden tab. The underlying technique was inspired from a community post but I used a totally different ap…

Mastering Power BI will likely be published by the end of March or April at the latest. Amazon, Packt, and other sites may soon be updated to reflect this change. Table of Contents The following ch…

Today we presented at the BI Bake Off session at Gartner Data and Analytics Summit in Grapevine, Texas and we are happy to share the report with everyone in this post.

The MVP Global Summit is happening this week in Redmond, WA. We are super excited to connect with all the MVP's and welcome them to our communities. What is the MVP Summit? The MVP Global Summit is a multi-day event that is hosted at the Microsoft headquarters in Redmond and in Bellevue, Washingt...

Before machine learning, we need to go through two main processes: Data preparation and Data wrangling. Data preparation is about the collecting data from resources, integrate and load data in one res…

Your First Co-Development Project P3 has tried many different flavors of our brand of “consulting” through the years, but co-development projects that combine real projects with coaching and knowledge transfer have turned out to have been the sweet spot in terms of success. Sometimes we are hands-on in the build

This month is a very exciting month for us! We are making several of our most popular connectors generally available, including SAP HANA. Bookmarking is also now generally available, which means you c…

I’m excited to announce the ability to share content with users using their personal email accounts, making it easier to share data with people outside of your organization. Previously, you could…

As we saw in a previous post, there are many things that we need to consider when dealing with Excel files since even the extension of an Excel file can dramatically impact your solution and how Power Query interprets the contents of that file. In a more broader sense, we also need to take in …

For the last two days, I have been with Microsoft Data Journalism Team in CAR conference. If you are a data journalist, Microsoft can help you (for free, by the way) to get your stories out. Learn more here. Here is a report that I prepared for the conference, to grab some attention by the …

In order to deliver Business Intelligence (BI), one must understand what BI is comprised of. Yet, there seems to be a lot of dissonance on what BI really means. Starting with its sole definition, people quite often tend to define BI as software — which is a fundamental mistake. In this article, I introduce my …

Hello again P3 Nation! I’m SUPER excited today to talk about an updated feature in Power BI Desktop. This month had a bunch of updates, all of which are pretty great. Some of my favorites are that bookmarks are now out of preview, among others. In fact, that full list of updates can be found here. What I’d like to

If you have ever started a sentence with “I’m seeing a strange issue in my Power BI Desktop report” and wondered how to investigate, this article is for you. Over the past few years of troubleshooting Power BI Desktop customer issues, I’ve created a checklist that often helps to identify a root cause within a...

Power BI March 2018 version, released on: 7th of March – 2.56.5023.861 Here’s the complete list of March features: Reporting Report page tooltips (preview) Bookmarking is now generally availa…

Accessibility is often overlooked or ignored when it comes to reporting and data visualization. I think there are two reasons why: We often don’t consider user scenarios with which we aren…

Recently I had the pleasure of migrating a SSRS 2017 instance to an instance of Power BI Report Server. I was really looking forward to it, since it means we would have everything in one single portal: paginated reports, Excel workbooks and of course Power BI Desktop reports. We had a new virtual ma

The sharing Power BI Content expanded further on 08 Mar 2018, where by you can now share content with email addresses such as Outlook.com or Gmail.com In this blog post I will walk through how this…

There have recently been some changes to Power BI with regards to the new features which I will detail below. Which I also have updated in my InfoGraphic In the latest version of both Power BI Desk…

About two years ago I wrote a blog post on how to connect to a Power BI Desktop model from different tools like SSMS, Excel and SQL Server Profiler. A big chunk of that blog post was about different ways of finding Power BI Desktop local port. Having the port number is crucial if you … Continue reading Four Different Ways to Find Your Power BI Desktop Local Port Number →

In this post I clarify the differences between "DirectQuery" and "Connect Live" in Power BI Desktop. Those terminologies look to be very similar, but, they are very different indeed. Read this article to find out more.

The Data & BI Summit, held in Dublin, Ireland 24-26 April is quickly approaching and we are happy to announce our keynote session and speaker.

Feeling bogged down by all the reports you need to create for your AdWords campaigns? Columnist Frederick Vallaeys has put together a script that may help.

Create custom tooltips for visuals using drag-and-drop

I was recently testing out the new Persistent Filters in Power BI and initially it would work with some reports and not with other reports. I even looked at imported data models, vs DirectQuery/Liv…