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.

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

You can really change up the look and feel of Power BI reports by utilising this simple technique or pattern. By adding a manual disconnected table and using the SWITCH function your report can take a different shape almost immediately.

Read more...

Attachment

 

Do you or your users wonder how recent the data they are seeing in Power BI is? If so, there are two new easy-to-use capabilities in Power BI that make it easier for you and your users to understand the status of the data in dashboards.

Read more...

Are you facing issues while refreshing CRM Online Data in your power BI reports?

Has your customer reported report failure or the message "Unable to read data from the transport connection"?

Read on for an alterntive approach to the OData connector to access CRM Online Data using FetchXML!

Read more...

There were already written few blog posts both about Row Level Security. I would like to add one more about this topic. I use this pattern for several years in SQL Server Analysis Services. Biggest advantage of this approach is, that you don’t have to fight with table relationships, which can be sometimes tricky to make work correctly.

Read more...

Attachment

Are you looking to test and implement Dynamic Row Level security. But it seems like it just does not want to work as you are expecting it to? Well in this blog post I give you some tips in order to ensure that you can get it up and running.

Read more...

This time we will look at the new way of connecting dynamically to a data source within Power BI Desktop. As with monthly power bi desktop updates we see new features getting released that makes it even more enterprise capable and solve real world problems that we face in day to day work. Power BI Desktop update for July 2016 included ability to reference queries as a source for parameters and so we are going to look at how to achieve dynamic selection of source using query parameters.

Read more...

The Languages of Power BI

by smoupre Super Contributor on ‎09-16-2016 08:39 AM - last edited on ‎09-29-2016 11:37 AM by Jessica Regular Visitor

Struggling with deciphering all of the various languages used with Power BI? Confused about when to use DAX versus "M" versus SQL, versus R? Fear not, this article will clear up the confusion and set you straight on all of the various languages of Power BI and when to use them. Each language you will generally encounter when using Power BI is covered including what it is, when to use it, where to use it, why you would use it, how you would use it and its overall level of difficulty ranging from 1 being easiest to 5 being the hardest.

Read more...

Tired of creating Power BI calendars? Well, me too, so let's put a stop to that.

 

In this blog post you will learn how to create (or download mine) a proper calendar that ”self-generates” when you open the file and is configurable.

If you download mine, you most likely will need to add columns that are relevant to you, but using the methodology explained in the post, you will do it only once.

 

Note: You need to have the latest Power BI Desktop update installed.

Read more...

Sentiment Analysis in Power BI

by DataChant Member on ‎08-04-2016 10:35 PM - last edited on ‎08-22-2016 04:28 PM by Power BI Admin Sandy

You may think that Sentiment Analysis is the domain of data scientists and machine learning experts, and that its incorporation to your reporting solutions is the domain of advanced developers and expansive IT projects. Well, today this is going to change.

 

Today I will show you how to gain Sentiment Analysis insights without the help of machine learning gurus or software ninjas. All you need to do is open your Power Bi Desktop and follow the steps below.

 

Oh, and to make it fun, let's pretend we are the social media analysts of the US Presidential Candidates, and analyze the sentiment of their Facebook posts. When we are done, we will be able to tell who is more positive on Facebook, Trump or Clinton, and if we see a trend of positivity or negativity over time.

 

Are you ready to begin? Here is the dashboard you will be able to create if you continue reading.

 

Screenshot_36.png

Read more...

Maps in power bi have improved significantly over past few releases and works fine across desktop, service and mobile app. However I recently saw a post by user where he had several addresses listed in the dataset and when plotted on map he realised number of plottings on map seemed little less than actual records in the dataset. Upon investigation it was found some addresses where not listed on Bing Maps but they were on Google Maps. If there was latitude longitude values it would have been easier since they would come up on Bing maps regardless of the address. That prompted me to explore the idea of geocoding and reverse geocoding in Power BI.

Read more...

Attachment

On previous blog posts, I have showed you how to create monitoring dashboards for both Google Analytics and Adwords.

I use those dashboards myself even though I am not a big fan of monitoring dashboards. Here is why:

 

Are monitoring dashboards useful? Yes, they surely are, specially in picking up variances and allowing you to react and learn from changes.

 

Are they needed? I would like to answer NO to that one.

 

One of the greatest features that Google analytics have, is Intelligence alerts where you get an email when variances occur (set up by google and yourself) and therefore you eliminate the need for those awful monitoring dashboards.

 

Can we do this in Power BI? Yes, with a but..

Read more...