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.

Meet Datanaut Flox!

by Jessica Regular Visitor ‎06-08-2017 10:29 AM - edited ‎06-08-2017 10:30 AM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Flox.


Meet Datanaut Appleta Patel

by Jessica Regular Visitor ‎06-07-2017 12:55 PM - edited ‎06-07-2017 12:57 PM

This week we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Appleta Patel.


Meet Datanaut Xander Cell

by Jessica Regular Visitor ‎06-06-2017 11:59 AM - edited ‎06-06-2017 12:05 PM

Yesterday we announced some of the community events you can expect at the Microsoft Data Insights Summit next week, and debuted the Datanauts, a collection of space defenders representing Excel, PowerApps, Flow, and Power BI.


Today, meet Xander Cell.


First look at Power BI Report Server

by darogael Frequent Visitor on ‎06-06-2017 11:46 AM

Power BI Report Server Preview was made available early May 2017 and this blog walks you through the installation, configuration and ends with a demo. The demo video shows how a report can built and added to the Power BI Report Server.


Can't make it to Microsoft Data Insights Summit? We’ll bring the conference to you!


We’re livestreaming our three keynotes and nine of our most popular breakout sessions, June 12–13, 2017 so you can learn alongside attendees. As Microsoft’s conference for business analysts, the Microsoft Data Insights Summit is filled with strong technical content to help you build a data culture at your organization.


See the full livestream schedule in this post. Mark your calendar and get ready to transform the way you work!


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


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


Extracting Report Level measures DAX using SQL Profiler output

by XLGeek Visitor ‎05-15-2017 04:58 PM - edited ‎05-15-2017 05:01 PM

In the May 2017 release of Power BI Desktop a new ‘report measures’ feature was released. It allows users who have connected Power BI Desktop to an external Analysis Services tabular model to write their own measures using DAX. These measures are stored within the report, and sent in the queries back to the underlying model. Any user who has access to query the model can do this – just the same as if they were using Excel or SQL Management Studio to connect to the SSAS server.



Don’t forget to submit your Power BI Pride 2017 videos – the deadline is quickly approaching (due: May 14, 2017).


Known for his award-winning global achievements in infographics and multimedia as a professor, author, journalist and designer, we are excited to welcome data visualization expert Alberto Cairo back to the Microsoft Data Insights Summit, taking place June 12-13, 2017 in Seattle. This year Alberto will provide a special guest keynote focused on the different dimensions of data visualization and how to entice your audience to engage with your information.


As I remember managers used to love SSRS reports for their availability of traffic light indicators which are useful way of measuring KPIs, trends etc. During my recent Power BI engagements with clients I have been asked few times if similar can be achieved in Power BI and my answer to that was, yes by pinning SSRS reports into Power BI which is essentially using SSRS and only with version 2016 but during the process I also discovered alternative approach which I want to highlight below.


Through utilizing the flexibility of the Power BI data model and the power of DAX you can develop some unbelievably compelling visuals and reports. I'm going to take you through the steps you need to take to make this work well, so that you can create reports like this....I call this technique MULTI THREADED DYNAMIC VISUALS


dynamic vsiuals.JPG


Learn how to get the most from your data — and the Microsoft tools you use every day — at the Microsoft Data Insights Summit, the company’s user conference for business analysts. Now in its second year, the event is packed with strong technical content, hands-on workshops, and a great lineup of speakers. And back by popular demand, you can now book an appointment with a Microsoft expert with our recently launched online Schedule Builder.


Hi, everyone!


Are you an avid user of Power BI products? Are you passionate about your language's quality? If so, a new forum (Power BI Language Quality) will allow you report and discuss language quality issues. You can also ask about Power BI Localization team, their processes and product languages. Your feedback will help us improve localization experience of Power BI products!

The list of supported languages are described in Power BI documentation.  


How to report language translation issues for Power BI on this forum (https://community.powerbi.com/t5/Power-BI-Language-Translation/bd-p/PBI_Lingusitic_Quality )?


Post your translation issue in the group & include the following information

Power BI Product/App/Service Name:

Language affected:

Current Translation:

Steps to reproduce the error:

Suggested Translation:

Corresponding English Text (if known):

Reason for change:

Please attach a screenshot of the issue to the post if available.

Platform if known.

Power BI Free vs Pro Infographic

by guavaq Super Contributor on ‎04-18-2017 05:01 PM

I have created an Infographic where you can view which options are free and which options require a Pro license. 


This will hopefully make it easier to understand if you use a particular option, if it will require a Pro license.


The previous blogs in this series showed how to put Power BI on top of Trello. Now we go for the jugular ad build a full-on data model. 


Once Power BI is connected to Trello, it then needs to look at the actual Trello cards. Here's how.


With more than 5 million copies sold in 40 countries, Freakonomics is a worldwide phenomenon — and we’re thrilled to announce that authors Steven Levitt and Stephen Dubner will join us for a special guest keynote at Microsoft Data Insights Summit, taking place June 12–13, 2017 in Seattle.


Part Two: Linking Power BI to Trello (deep dive)

by factgasm Frequent Visitor on ‎04-10-2017 12:15 PM - last edited on ‎04-10-2017 12:24 PM by Jessica Regular Visitor

Part Two of the Measure Trello with Power BI blog series, this covers a detailed look at the inner workings of Trello.


Part One: Linking Power BI to Trello (overview)

by factgasm Frequent Visitor on ‎04-05-2017 10:54 AM - last edited on ‎04-10-2017 12:23 PM by Jessica Regular Visitor

Part One of the Measure Trello with Power BI blog series, this covers a quick look at the inner workings of Trello.


How to: Measure Trello with Power BI (Blog Series)

by factgasm Frequent Visitor on ‎04-05-2017 10:50 AM - last edited on ‎04-14-2017 02:37 PM by Jessica Regular Visitor

If you use Trello and want to measure your activity, there is no better visualization tool than Power BI. However, putting Trello behind Power BI is, well, tricky. This is the master post in a series of blogs in which we show you how to do this.


We recently shared our full session catalog for this year’s Microsoft Data Insights Summit. This week we want to highlight some of the featured speakers  we’ll have at the event. The Data Insights Summit includes an amazing mix of BI experts, product partners, community members, and Microsoft product engineers – all at the conference to help you learn how make the most of your data. We’re thrilled to spotlight Amanda Cofsky, Brian Jones, Chris Webb, Danielle Dean, Jennifer Stirrup, Justyna Lucznik, Kim Manis, Marco Russo, and Rob Collie.


How can you gain a competitive advantage using Microsoft Flow and Power BI?


To demonstrate the power of these two services, we will create a fictitious startup called StockholmICE that will compete in the home delivery market of ice creams in Sweden.


(yes, despite the weather, people eat a lot of ice creams in Sweden J)


Curious? Great, keep reading!  


Vote now for the next Power BI t-shirt!

by Jessica Regular Visitor ‎03-29-2017 10:40 AM - edited ‎03-29-2017 10:41 AM

A week ago we asked you to submit new designs for our next Power BI t-shirt, and we had an amazing response! Now it's time to vote for your favorites.



In February, we announced that our Microsoft Data Insights Summit will return for the second year, and invited you to register and join us June 12-13, 2017 in Seattle, WA. This is THE user conference for Power BI, SQL Server BI, Excel, PowerApps, and Flow.


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


Have you ever wished that there was a forum where you could just hang out and talk Power BI? Not an online message board but a live conversation with live people. You could ask questions, share comments or seek guidance about whatever is on your mind.

Keep reading about my adventures with a "Radio Style" Power BI Talk Show, I host each Friday 9AM Pacific. The whole thing started when I was...


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.


We’re excited to announce the Microsoft Data Insights Summit, our user conference for business analysts, is back June 12 – 13, 2017 in Seattle, WA. This two-day event is designed to help you identify deeper insights, make better sense of your data, and take action to transform your business. The conference sold out last year – and we don’t want you to miss out – so we encourage you to reserve your spot soon.