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.

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 MindyJ

Measure enterprise Power BI usage with Office 365 Audit Logs.

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

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

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

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

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

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

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

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

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

Read more...

Creating Slopegraphs in Power BI

by deldersveld Established Member on ‎05-22-2017 09:21 AM

Did you know that it's easy to transform Power BI's Line Chart into a Slopegraph? No DAX or fancy workarounds are required. Slopegraphs are a great way to judge the rate and magnitude of change by looking at the steepness of a line’s slope. With a slopegraph, it is also easier to discern how different elements or categories trend compared to others.

 

Slopegraph Sample

Read more...

Last week we launched the Power BI Blogroll! It's a place for external bloggers to share the best of their own posts, and for readers to stay on top of what folks from around the world are saying about Power BI. Read on to learn more about the blogroll and how you can participate...

Read more...

Many of you know that Power Query is an amazing tool for data import and data transformation. It is powerful an easy to use. But there is always a BUT. It is a pain to write custom M code. The Power Query Advanced Editor comes without intellisense (auto completion), no parameter hints, no syntax highlighting, no help texts, which explain what the functions do, no nothing. The fact, that M is case sensitive doesn’t make it easier at all. In 2015 I read the following article, written by Matt Masson. Matt is a Senior Program Manager at Microsoft and member of the Power BI Developer Team. He showed how to create an editor for Power Query with Notepad++. At that time I did not even know that it was possible to create a custom language in Notepad++. 

Read more...

There is a wealth of information with regards to Power BI, but not a simple to use Info Graphic that can be viewed to show people how all the pieces of Power BI are strung together.

 

In this quick and easy to read blog post I share my Info Graphic with the community.

Read more...

I recently came across a particular data modeling and analysis challenge that I felt would be beneficial to generalize as I believe the basic design pattern has numerous uses. This blog post summarizes the challenge, discusses the possible uses of the design pattern and presents a simple solution as well as a more complex solution that factors in such things as row level security. A special thanks to @Vvelarde for his guidance in helping to solve the final pieces of this puzzle.

Read more...

Power BI y Azure Table Storage

by jbocachica Member on ‎01-03-2017 10:29 AM

Azure Table Storage como repositorio, pros y contras!

Read more...

Consumir listas de Sharepoint puede sonar a algo trivial, sin embargo cuando llega la hora de actualizarlas es cuando llegan los problemas.

Read more...

Q&A (Natural Query Language) is by far one of the features that I find really gives the WOW factor when showing people the capabilities of Power BI. And in my opinion it is awesome.

So I thought I would give a quick blog post in terms of how best you can leverage this, and hopefully also enable you to be able to WOW people.

The aim of this blog post is to show you how to quickly see and understand how use the WOW features in Q&A

Read more...

In this part of our Text Analytics tutorial we will learn how to extract key phrases from text messages with a little help from Microsoft Cognitive Services Text Analytics (AKA Azure Machine Learning). In the first part of the tutorial here we imported Clinton's and Trump's Facebook posts. It's time to learn how to extract the Key Phrases from those messages using Microsoft Cognitive Services Machine Learning, and with no help from IT, Developers or Data Scientists.

 

When we are done, we will be able to create stunning reports that will correlate key phrases with our metrics. In our example: We will be able to see which key phrases triggered the highest number of shares, and slice them by positive, neutral or negative sentiment, as shown in this report:

 

Screenshot_59.png

 

Read more...

Text Analytics in Power BI - Extraction of key phrases from Facebook messages (part one)

by DataChant Member on ‎11-10-2016 10:51 AM - last edited on ‎11-10-2016 11:45 AM by Jessica Regular Visitor

In my last community blog here we learn how to apply sentiment analysis in Power BI with Microsoft Cognitive Services API (aka Azure Machine Learning) and with no help from IT, developers or data scientists. In the follow-up articles we drilled down into different aspects of the Sentiment Analysis implementation in Power BI, and shared the technique in several community events. Following the great interest in these scenarios, in today's blog post we will use similar technique to extract key phrases from text messages. To make it interesting, we will pull Facebook messages from the public pages of Clinton and Trump, extract their key phrases, and correlate it with engagement levels and sentiment in cool visuals (As seen here).

 

Screenshot_21.png

Read more...

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