In Gratitude for a Microsoft MVP Award

Humbled and honored, I received an email from Microsoft late yesterday stating that I was awarded a 2017-2018 MVP for contributions to the Data Platform! Thank you to everyone who reads this blog, follows me on social media, and has helped put me in a position to receive this award! Thank you to Microsoft as well…

Using DAX to Normalize Data in Power BI

A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon chart and Slopegraph in Power BI without the use of custom visuals. In many cases, we can use DAX, selective filtering, or other tricks to…

What *Undocumented* R Packages Exist in Power BI Service?

In my last post, I examined the list of R packages supported in Power BI Service. After some additional research, it turns out that I should have titled it “documented” instead of “supported”. Why is that? In addition to the 361 documented packages, there are over 200 undocumented R packages currently available to users in Power…

What R Packages Are Supported in Power BI Service?

Microsoft maintains an official list of supported R packages available for use in the Power BI Service. There are currently 361 documented packages. While you are not as limited in your package selection when using Power BI Desktop, you have to be more careful if you are working with R in the online Service. If you use…

10 Ways to Create Maps in Microsoft Power BI

Last year, I wrote a post entitled 5 Ways to Create Maps in Microsoft Power BI. With the introduction of numerous mapping changes in Power BI since then, I felt it best to provide an update as of June 2017. As I mentioned in last year’s post, each mapping method could have advantages in different circumstances. The…