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.

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

Meet Datanaut Flox!

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

Read more...

Meet Datanaut Appleta Patel

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

Read more...

Meet Datanaut Xander Cell

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

Read more...

First look at Power BI Report Server

by darogael New Member 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.

Read more...

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!

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

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.

Read more...

Attachment

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

Read more...

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.

Read more...

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.

Read more...

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

Read more...

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.

Read more...

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.

Read more...

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. 

Read more...

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

Read more...

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.

Read more...

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 Power BI Admin Jessica

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

Read more...

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 Power BI Admin Jessica

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

Read more...

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 Power BI Admin Jessica

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.

Read more...

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.

Read more...

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!  

Read more...

Vote now for the next Power BI t-shirt!

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

 

Read more...

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.

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

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

Read more...