Power BI Troubleshooting Checklist

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…

1

Importing a .dbf (dBase) file into Power BI

How can I import data from a .dbf (dBase) file into Power BI? Today’s Power BI Mailbag Question comes from a friend who often works with geospatial data and, as a result, ends up with several different shapefile formats, including .dbf (dBase) database table files. There are several blog articles around shapefile mapping options in…

11

Understanding the differences between “Power BI Desktop” and “Power BI Desktop Optimized for Power BI Report Server”

Over the past few weeks, I’ve been spending a lot of time discussing Power BI Report Server with my customers and colleagues. One of the most common questions I’m asked is: What are the differences between “Power BI Desktop” and “Power BI Desktop optimized for Power BI Report Server”?   In this blog post, I’ll…

10

Troubleshooting a Power BI Dataset Refresh Error

Troubleshooting a Power BI Dataset Refresh Error I investigated a Power BI Dataset Refresh issue tonight that had been successfully refreshing until earlier in the day, when it began to fail consistently. The report solution is an extension of the Power BI Bing News Solution Template (which is really impressive!). In the Power BI tenant,…

3

Exploring Big Data: Course 2 – Analyzing and Visualizing Data with Power BI

(This is course #2 of my review of the Microsoft Professional Program in Big Data) Course #2 of 10 – Analyzing and Visualizing Data with Power BI Foreword: For the Analyzing and Visualizing Power BI course, I have asked my outstanding colleague Steve Taylor to share his experience recently completing the course. I originally took…

0

My Journey into the Microsoft Professional Program (MPP) in Big Data

  Exploring Big Data with the Microsoft Professional Program (MPP) After the introduction of a very successful online education curriculum focusing on Data Science, Microsoft recently announced its next Microsoft Professional Program (MPP) in Big Data. I absolutely loved the Data Science program and have decided to start on the Big Data courses this week….

1

Power BI Desktop and “The Case of the Missing Taskbar Icon”

Power BI Desktop and “The Case of the Missing Taskbar Icon” For the past two years, I’ve installed and reinstalled Power BI Desktop builds hundreds of times on numerous machines. My typical pattern is to install the software and pin it to the taskbar. After pinning the application to the taskbar, I see the standard…

2

IP Address Mapping in Power BI

I recently assisted in troubleshooting an issue where the error logs contained several unknown IP addresses. During this process, I created a quick dashboard in Power BI to display the location of these IP addresses on a map to get a better understanding of where the machines were located. I used a free service from…

5

SQL Nexus 2017 Conference Recap

SQL Nexus 2017 – Conference Recap   Nearly 500 Microsoft data professionals attended SQL Nexus 2017 this week in Copenhagen, Denmark, with specialized tracks covering data platform, business intelligence, application and DB development, database administration, AI/data science, and IoT. I was honored to attend this year for the second time as a speaker for two…

0

Tracking LinkedIn and Twitter social media shares in Power BI

How to: Retrieve Twitter & LinkedIn share totals for a list of URLs in Power BI / Power Query / M If you have a Power BI or Power Query report that contains a list of URLs, the following M functions can be used to add the number of times the URL has been shared…

2