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.

Power BI User Day Holland 2018 | March 23-24, 2018 | The Netherlands

by Power BI Admin ‎02-06-2018 05:22 PM - edited ‎02-06-2018 09:08 PM

Power BI User Day Holland is back for a second year!  This year’s conference will be filled with strong technical content, vibrant speakers, and Power BI experts. 

Read more...

Joining tables In Power BI using Power Query and/or DAX

by ruthpozuelo Regular Visitor on ‎02-06-2018 09:54 AM - last edited on ‎02-06-2018 09:57 AM by Power BI Admin

I have done a few videos on YouTube explaining how to join tables using Power Query or DAX. If you follow the channel, you probably have seen the videos and this blog post will serve as a compilation of all the material.
 
However, if you are new, this will serve as a tutorial for beginners on how to joins in Power BI. Either way, I believe this post will be useful for all, so let's get started.

Read more...

Create a nice-looking PBI Scoring System in 10 min (and make your Boss impressed)

by augustindelaf Member on ‎02-06-2018 07:26 AM - last edited on ‎02-08-2018 01:17 PM by Power BI Admin

The purpose of this tutorial is to create a nice visual that compares your products each to another, according to rules that you created.  In the end, your visual looks like a class of students where YOU give good/bad marks.

20be95_c186be1858a54501bac3e0a33e8fd4d9-mv2.png

 

I had the opportunity to present this dashboard (similar data model but different topic) at Microsoft France HQ in June 2017:

https://community.powerbi.com/t5/Data-Stories-Gallery/Business-Schools-Dashboard-France/m-p/187496.

Read more...

Attachment

Monday Motivation

by Power BI Admin ‎02-05-2018 08:45 PM - edited ‎02-05-2018 08:48 PM

We have some exciting things planned for February! But first, let’s kick off the month with a recap of last week’s top contributions.

Read more...

Recently I put on a virtual workshop as part of the Enterprise DNA Webinar Series, which was all about how to set up your Power BI models for advanced insights. It was very well received by over 400 Power BI users who registered, so I thought I would do a review here for the community blog.

 

Advanced Insights with Power BI.JPG

 

 

 

 

 

 

Read more...

Working with ranges (Numbers/Dates) in Power Query/Power BI - Part 2

by rsaprano Frequent Visitor on ‎01-30-2018 10:31 AM - last edited on ‎01-30-2018 10:34 AM by Power BI Admin

This 2-part blog post is for working with ranges/bands of numbers in the Edit Queries stage of Power BI. Part 1 covers inexact lookups - looking up a number against a set of bands/ranges and returning the appropriate band which the number sits in. The second part looks at finding overlapping ranges - the scenario where we have two ranges/bands of numbers (rather than having one number and one set of bands) and we want to see the areas of overlap between the ranges.

Read more...

Data & BI Summit 2018 | April 24-26, 2018 | Dublin, Ireland

by Power BI Admin ‎01-29-2018 04:24 PM - edited ‎01-29-2018 04:28 PM

Eager to save on your Data & BI Summit registration? It’s easy: go to databisummit.com, take advantage of Early Bird pricing and save up to €400. Early Bird pricing for Data & BI Summit ends 31 January.

Read more...

Monday Motivation

by Power BI Admin on ‎01-29-2018 04:15 PM

January is coming to a close, and this is the final Monday Motivation for the month

Read more...

Difinity Conference 2018 | February 12-14, 2018 | Auckland, New Zealand

by Power BI Admin ‎01-29-2018 11:37 AM - edited ‎01-30-2018 12:08 PM

Want to learn more about Power BI and Business Intelligence?  Come to the Difinity Conference 2018 in Auckland, New Zealand.  It is the largest Microsoft Power BI and Business Intelligence conference for the Australia and New Zealand area. During this three-day conference, 40 speakers from all around the world (U.S., Europe, Asia, Australia, and New Zealand) will speak at Difinity Conference 2018. This conference will be held at the Cordis Hotel in Auckland, New Zealand February 12-14, 2018. 

Read more...

Year in Review: Featured Entry

by Power BI Admin on ‎01-26-2018 03:05 PM

As the “Year in Review” contest starts to wrap up, check out this week’s featured entry!

Read more...

Working with ranges (Numbers/Dates) in Power Query/Power BI - Part 1

by rsaprano Frequent Visitor on ‎01-26-2018 09:10 AM - last edited on ‎01-30-2018 10:38 AM by Power BI Admin

This 2-part blog post is for working with ranges/bands of numbers in the Edit Queries stage of Power BI. The first part covers inexact lookups - looking up a number against a set of bands/ranges and returning the appropriate band which the number sits in. The second part looks at finding overlapping ranges - the scenario where we have two ranges/bands of numbers (rather than having one number and one set of bands) and we want to see the areas of overlap between the ranges.

Read more...

Monday Motivation

by Power BI Admin on ‎01-22-2018 03:06 PM

Another Monday, another Monday Motivation to get your week started right!

Read more...

Year in Review Progress!

by Power BI Admin on ‎01-19-2018 12:46 PM

The “Year in Review” Contest is off to a great start, and we’re excited to feature a randomly selected entry each week.

Read more...

For all of those that had Dr. Marquarts out there, this is for you.

Read more...

Mean Time Between Failure (MTBF) is a common term and concept used in equipment and plant maintenance contexts. In addition, MTBF is an important consideration in the development of products. MTBF, along with other maintenance, repair and reliability information, can be extremely valuable to organizations to help identify problematic systems, predict system outages, improve product designs and improve overall operational efficiency and effectiveness. As such, it would be beneficial to understand how to implement this metric within Power BI.

Read more...

In Part 1 of this blog, we extracted Audit Log data from Office 365 using PowerShell and stored it in SharePoint for the purposes of quantifying Power BI adoption. In Part 2 we will transform and visualize the Audit Log data using Power BI.

Read more...

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

Measure enterprise Power BI usage with Office 365 Audit Logs.

Read more...

Monday Motivation

by Power BI Admin ‎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. 

Read more...

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

Read more...

Kaplan Meier Survival Curves with Power BI - Part 1

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

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.

Read more...

"Year in Review" Contest with Power BI

by Power BI Admin ‎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. 

Read more...

Something BIG is coming!

by Power BI Admin 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.

Read more...

Monday Motivation

by Power BI Admin ‎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. 

Read more...

Pardon Our Dust, We’re Making Changes

by Power BI Admin ‎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.

Read more...

Power BI "Bookmark Feature" Contest

by Power BI Admin ‎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! 

Read more...

Monday Motivation

by Power BI Admin 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. 

Read more...

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

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

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.

Read more...

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.

Read more...

Power BI staff wins gold Stevie Award for Women in Business

by Power BI Admin ‎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

Read more...

Monday Motivation

by Power BI Admin ‎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.

Read more...

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