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.

Pardon Our Dust, We’re Making Changes

by Power BI Admin MindyJ Thursday - last edited Thursday

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 mbenjamin Tuesday - last edited Tuesday

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

Read more...

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 guavaq Super Contributor 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.

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 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

Read more...

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.

Read more...

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.

Read more...

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.

Read more...

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. 

Read more...

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.

Read more...

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.

Read more...

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

by Power BI Admin MindyJ on ‎11-16-2017 01:56 PM - last edited on ‎11-16-2017 02:15 PM by Power BI Admin mbenjamin

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.

Read more...

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).

Read more...

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.

Read more...

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.

Read more...

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.

 

Email-in_person-picture1_600x180_Sept_28_ggilio.jpg

Read more...

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

 

 

 

Read more...

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.

Read more...

Attachment

Using Change Tables to Compare Data

by guavaq Super Contributor 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.

Read more...

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

Read more...

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.

Read more...

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.

Read more...

New Webinars on Advanced Query Design and Power BI Embedded

by TedPattison Member ‎08-03-2017 05:58 PM - edited ‎08-03-2017 05:59 PM

 

After receiving 12 Microsoft MVP awards my work with SharePoint development, this week I finally received my first MVP award for Power BI and the Microsoft Data Platform. I guess you could say I am a Born Again MVP! I am very happy to be in the company of so many of my Power BI heroes such as Marcus Russo, Alberto Ferrari and Chris Webb. To celebrate this achievement I have scheduled two public webinars on Power BI next week in which I am going to present some in-depth content. I hope you can make it to one of these webinar and, afterwards, I will post the recordings to the Power BI community site for those who are interested but cannot attend due to time constraints.

Read more...

Pivot your Data using Power Query

by Excelside Established Member ‎08-02-2017 07:28 AM - edited ‎08-02-2017 08:01 AM

Yes, you read it right ! I am not going to talk about unpivot, which is probably one of the most powerful feature in Power Query, but Table.Pivot which happened to be useful for me a few days ago.

Read more...

Attachment

A Power BI Custom Connector for Youtube AnalyticsA Power BI Custom Connector for Youtube Analytics

Read more...

How to use your Office Theme as Power BI Report Theme

by DominikPetri Regular Visitor on ‎07-12-2017 01:10 PM - last edited on ‎10-24-2017 09:41 AM by Power BI Admin mbenjamin

Since Power BI Desktop’s March 2017 Update, it is possible to apply a color theme to your entire report. When you apply a so called “Report Theme”, all visuals in your report use the colors from your selected theme. Unfortunately, you can’t just import your Office Theme Colors into Power BI Desktop since they have different structures and filetypes. Therefore, I developed an Excel tool (the download link is at the end of the article) that converts your Office Theme into a Power BI Desktop Theme in 4 simple steps.

 

Excel tool to convert an Office Theme into an Power BI Desktop ThemeExcel tool to convert an Office Theme into an Power BI Desktop Theme

Read more...

Power BI - Overview Infographic

by guavaq Super Contributor on ‎06-26-2017 03:54 PM

With there being so many changes and updates to Power BI, I have created an infographic in which it covers all of the vital elements when looking at Power BI Free, Pro and Premium.

Read more...

We are very excited to give you a preview of what each of our 18 amazing customers will show you during the Customer Story sessions at the Microsoft Data Insights Summit on June 12 – 13 in Seattle. After much preparation, we've boiled down each presentation to 25 minutes with 5-10 minutes of every session focused on demos.

 

We've made sure we have depth and breadth of customers across several industries like sports, finance, technology, media, and more with many different capabilities showcased, including Microsoft Power BI, Power BI Mobile, PowerApps, R, Azure Machine Learning, IoT, and more. Here's a quick look at what you can expect during the event!

Read more...

In this blog post I show how to use Unicode characters to further leverage Power BI visuals within a table.

Read more...