Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

Measuring Power BI Adoption using PowerShell, SharePoint and Power BI - Part 1

by NormYoung Frequent Visitor on ‎01-09-2018 10:12 AM - last edited on ‎01-11-2018 12:48 PM by Power BI Admin MindyJ

Measure enterprise Power BI usage with Office 365 Audit Logs.


Monday Motivation

by Power BI Admin MindyJ ‎01-08-2018 04:57 PM - edited ‎01-08-2018 05:02 PM

Happy Monday!


This is the first official Monday Motivation post of 2018, and I can already tell it’s going to be a good year. 


Building on Part 1 of this series, Part 2 demonstrates how to separate out individual Departments.


Kaplan Meier Survival Curves with Power BI - Part 1

by on ‎01-04-2018 01:31 PM - last edited on ‎01-05-2018 12:27 PM by Power BI Admin MindyJ

Inspired by a post on the Power BI Community site, I read through this fine article by Chris Short on LinkedIn Pulse, Survival Curves in Tableau with HR Data. Overall, this technique looked really interesting and I wondered if I could do something similar in Power BI. Turns out that you can and this article will show you how.


"Year in Review" Contest with Power BI

by Power BI Admin mbenjamin ‎01-03-2018 10:08 AM - edited ‎01-05-2018 08:38 AM

Happy New Year! What better way to kick off 2018 than by entering this contest for a chance to win some fabulous prizes? Read the full blog post for details and the attached official rules. 


Something BIG is coming!

by Power BI Admin mbenjamin on ‎12-20-2017 02:49 PM

Here’s your chance to make your awesome story idea pay off! We’re excited to announce we’ll begin accepting entries for our biggest contest yet on January 3rd.  The winning entrant will walk away with an amazing prize.


Monday Motivation

by Power BI Admin MindyJ ‎12-18-2017 02:30 PM - edited ‎12-18-2017 02:31 PM

Happy Monday!


Chase away the Monday blues with the latest stats on some of the top kudoed authors from last week as well as our most active threads and newest members. 


Pardon Our Dust, We’re Making Changes

by Power BI Admin MindyJ ‎12-14-2017 02:24 PM - edited ‎12-14-2017 02:27 PM

We have exciting changes in the works for the Power BI community. The community is getting a makeover to make it easier to navigate and quickly find what you are looking for. We're redesigning our community to be cleaner, more interactive, and useful for our members.


Power BI "Bookmark Feature" Contest

by Power BI Admin mbenjamin ‎12-12-2017 09:38 AM - edited ‎12-12-2017 09:47 AM

Enter the Power BI "Bookmark Feature" Contest for a chance to win a Power BI Super Swag Prize Pack! 


Monday Motivation

by Power BI Admin MindyJ on ‎12-11-2017 04:04 PM

It’s that time of week again!


Let’s get the week started right and highlight some of the top kudoed authors from last week as well as our most active threads and newest members. 


How to enable Excel Pro’s to use Power BI Datasets

by on ‎12-07-2017 07:42 PM - last edited on ‎12-08-2017 04:50 PM by Power BI Admin MindyJ

In the steps below, I will demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available in the Power BI Service, as well as from Excel. NOTE: This currently only works on a PC.


In this blog post we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without needing a computer or server. We will do this by scheduling a Runbook in Azure Automation.


Power BI staff wins gold Stevie Award for Women in Business

by Power BI Admin MindyJ ‎12-05-2017 10:54 AM - edited ‎12-05-2017 10:33 PM

Have you visited the Power BI Galleries recently? You may wonder what inspired this rich resource for the Power BI community. In late 2016 Sandy Rivas, Community Strategy Manager for Microsoft’s Business Application Group, came up with an idea to motivate members to contribute to the community, educate each other, and celebrate the users through kudos. She worked with her all-woman team to create the Data Stories Gallery and then launched the Motivate-Educate-Celebrate campaign


Monday Motivation

by Power BI Admin MindyJ ‎12-04-2017 10:15 AM - edited ‎12-04-2017 10:17 AM

Kick the Monday blues to the curb with some Monday Motivation!

We’re highlighting some of the top kudo-ed authors from last week as well as our most active threads and newest members.


Toggle between a chart and a table

by SivaMani Established Member on ‎11-28-2017 04:24 AM - last edited on ‎12-01-2017 10:47 AM by Power BI Admin MindyJ

One of the most requested requirements from the Business users is to view the data in two different visuals, usually in a chart and table. With standard configurations in Power BI Desktop, we don't have the option to do this. But, we can get this by using the Bookmark and Selection Pane.


Weekly Hot Topics

by Power BI Admin MindyJ on ‎11-27-2017 03:53 PM

Last week there were some great conversations in the Power BI Community Forums. From troubleshooting, to best practices, to step-by-step tutorials, you’ve all contributed some valuable content and made this place a great resource for fellow Power BI users around the globe. So, in the spirit of celebrating community, we thought we’d start a weekly blog post shouting out some of our top-kudoed authors, new members, and lively conversations from the previous week.


Power BI Group management using Active Directory roles and PowerShell

by NormYoung Frequent Visitor on ‎11-21-2017 10:49 AM - last edited on ‎11-28-2017 10:50 AM by Power BI Admin MindyJ

Use PowerShell to maintain Power BI / Office 365 Groups. 


Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:41 AM - last edited on ‎12-06-2017 03:43 PM by Power BI Admin MindyJ

In my last blog post, Integrating PowerShell with Power BI (Part 1), I set up the connection between Power BI and PowerShell.  If you followed the steps in part one, you are set to start using this newly created integration.  In this post I will take a look at how we use the Power BI module and how to visualize the data in Power BI reports.


Integrating PowerShell with Power BI (Part 1)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:27 AM - last edited on ‎12-06-2017 03:40 PM by Power BI Admin MindyJ

Power BI is an extremely powerful data and visualization tool. It has opened a new world for me. But, the first thing I always think about when looking at Microsoft products is that there must be a way to control this with PowerShell. I did not find any useful information about any PowerShell module on the product pages.  After some googling, I found a module on the PowerShell gallery potentially created by a Microsoft employee.  What's surprising is that the module has been out for about 7 months and has barely 130 downloads.  Why hasn’t this been more popular? Hopefully I can help change this with a series of blog posts looking at the possibilities of Power BI and PowerShell.


Power BI Reporting Webinar: Transforming "Good" to "Great!"

by Power BI Admin MindyJ ‎11-16-2017 01:56 PM - edited ‎02-20-2018 06:26 PM

Failing to deliver a well-designed Power BI Report is perhaps the most common reporting pitfall.  What good is quality data if it is not presented in a way that is meaningful or easily understood? Someone without any prior knowledge should be able to quickly understand a report without explanation and be quickly drawn to the key elements you want them to view.  This webinar will walk through the common dos and don’ts of reporting in Power BI, using easy-to-learn techniques that bring data to life.


Help creating your JSON file template for themes using a Power BI file

by ruthpozuelo Regular Visitor on ‎11-14-2017 09:20 AM - last edited on ‎11-17-2017 08:28 AM by Power BI Admin mbenjamin


Have you tried to create a JSON file to manage the theme on your Power BI report? Not an easy task, right? I tried to do this last week, and I found it hard and confusing. Hours went by, and I was almost in the same place as when I started. My method was obviously not working, and the available documentation was not clear for me. I needed to do something else if I was going to produce a JSON file theme for my customer.  So, what to do? I use Power BI for everything, ok not everything, but almost everything. So, I used Power BI to create a documentation that I could understand, and finally my JSON file was done (or at least I did all that could be done, more on that on the later).


Comment Spam Policy Update for Power BI Community Forums

by Power BI Admin MindyJ ‎11-07-2017 04:18 PM - edited ‎11-09-2017 11:12 AM

Have you posted to the Power BI community recently and noticed some subtle changes? You may have published your post but been unable to find it on the site or you may have noticed that your post now appears under “My Unmoderated Items” in your profile. In either case, you do not need to resubmit your post; it is in the moderator queue waiting for approval before appearing on the live site. The changes you are seeing are part of an update to the Power BI Community.


Microsoft Certification Exam 70-778: Analyzing and Visualizing Data with Power BI

by TedPattison Member on ‎11-01-2017 04:06 PM - last edited on ‎11-02-2017 01:34 PM by Power BI Admin MindyJ

So many people on the Power BI team at Microsoft have been working day and night for the last two years making the Power BI platform and its constantly-evolving feature set more competitive against Tableau, the industry leader. Those of us outside of Microsoft in the Power BI community can also help to make Power BI more competitive against Tableau by working together to increase the amount of Power BI expertise in our industry. Power BI adoption numbers are sure to increase as companies become more confident in the fact that they can find the right people with the talent and skills to design custom Power BI solutions and to manage the wide-scale distribution of content published to the Power BI service. This is why Power BI certification will become increasingly important as we move into 2018.


Register to join Microsoft Business Forward in Chicago

by Power BI Admin MiguelMartinez ‎10-24-2017 12:34 PM - edited ‎10-24-2017 12:35 PM

Hear from Microsoft executives Judson Althoff EVP Worldwide Commercial Business and James Phillips CVP Business Applications Group about the latest advancements in Dynamics 365 applications to help you transform the way you do business.




Recently I ran a free workshop for all of those connected to Enterprise DNA in some way. It was all about dashboarding and how to develop really compelling reports. Here's the reporting dashboard I showcased as I ran through my best practice visualization techniques - I'm making it available for download here along with the workshop recording


Multi Year Performance.JPG





The "Disconnected Table Trick" is a fairly well known technique in the world of Power BI but I could not find a community blog article that actually presented it. This article explains and demonstrates the use of the Disconnected Table Trick in the context of solving a recent problem around tracking and reporting attendance that came up at a recent Columbus Azure ML and Power BI User Group (CAMLPUG) meeting.



Using Change Tables to Compare Data

by on ‎10-12-2017 09:32 AM

Have you ever wanted to compare changes in your data without having to create duplicate copies, as well as make it really simple and easy for users to do some self-service comparisons?

In this example I am going to show how I created and then used Change tables to compare data where you can select multiple items to compare.


Walk Through Of Many Ranking Techniques using DAX in Power BI

by EnterpriseDNA Regular Visitor on ‎10-09-2017 01:49 PM - last edited on ‎10-09-2017 01:50 PM by Power BI Admin mbenjamin

There's so many applications and situations where utilising ranking techniques really add a lot of value in your analysis.
I've created many videos over at Enterprise DNA TV which showcase these techniques, so I thought I might review some of these here so you can learn about them more.
I'm going to review these techniques but don't forget you could apply these a number of different ways and in lots of situations.
1. Find Your Top Customers Through Time Using RANKX in Power BI w/DAX
2. Discover Top Salespeople Contribution To All Sales in Power BI w/DAX
3. Discover The Best Selling Day For Your Products w/DAX in Power BI


Enterprise DNA TV logo2.png


London and Copenhagen wrapped up their two-day Power BI World Tour events in August. To read more about the highlights from the World Tour events in London and Copenhagen, check out the event recaps.


Thanks to all of you who were able to attend my webinar today titled Power BI Embedding Version 2 – The Full Story. I am starting to get the idea that people in Norway are head-over-heels-crazy for Power BI. I say this because our good friend, Hans Kristiansen of Capgemini, was able to gather 79 Norwegians members of his local Power BI user group into a single room to participate my webinar today. For those of you who are interested in the content but were unable to attend, I have posted to webinar recording in the Webinars and Video Gallery of the Power BI community site at this link.


Join Blog
Interested in blogging for the community? Let us Know.