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.

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


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.


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.


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



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. 


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.


What is R-script?


R is a language and environment used for statistical and graphic computing. It is a modification of the S language, so there is code written in S, which is capable of being implemented in R without modifications.

R provides a wide variety of statistical models (linear and nonlinear models, classical statistical tests, time series analysis, classification, grouping, etc.) and graphic techniques, which makes it a very extensible and manipulative tool on the part of user.

One of R’s strengths is the ease with which publication graphics can be produced with good quality and design, including mathematical symbols and formulas where necessary.


Being an analyst with modern visualization technology is fun and enriching. Who doesn’t enjoy a stunning visual with useful and easily consumable insights? The reality is: even the most thoughtful authors have blind spots. Why? Because authors have significant amount of background knowledge that is not carried through via visualizations. In the absence of that, users relay on visual cues and the knowledge they learn from elsewhere to interpret what they see. This often cause communication gaps in data visualization, particularly in situations where report is authored by one person and used by many users from different teams, different backgrounds, and have different background knowledge and chart reading abilities.    


Using DAX to compare data or metrics over time is incredibly efficient. Using a range of techniques in this post I'll show you how to analysis performance of these metrics over multi-year time periods.


Multi Year Performance Analysis.JPG


Sure, there's a nice video on how to use the new Power BI Preview Web Part in SharePoint Online. But, there's also a few important pre-requisites that the video does not cover. Fear not, this article will get you up and running with the Power BI Preview Web Part in no time!


Security and Power BI Profiles

by gastoncruz Frequent Visitor on ‎02-08-2017 10:18 AM

Define Profiles

One of the queries that ask me many time is about problems that have many organizations and that consist in generate a report (sales, marketing, finance) but which claim that users who belong to a certain department, zone, region category assigned permissions only to view information about a target zone.

This is the case, for example, sales representatives can only view sales in the area to which they were assigned. This is the case that Marketing Managers must have their focus on a particular region, or in certain categories of products which are promoting.

Let’s step through an example where this profiling is defined from Power BI Desktop configuration, to implementation live in an example once published the report in Power BI Web.


Inserting data into a PowerBI Dataset via Flow and the REST APIs

by Power BI Admin chass on ‎01-25-2017 12:28 PM - last edited on ‎01-25-2017 04:28 PM by Power BI Admin Jessica

Last week I was playing with the very cool Rest Getting Started Sample (written in C#). I morphed it into a big loop that deleted all the rows in the dataset, and sent a row with a random value from 1-10. The reason I did this was to try out the new Flow integration with Alerts so I could demo sending emails to groups of people as a result of an alert.


I tweeted about this demo, and had a bunch of private requests from people hoping for a sample of updating data in Power BI directly from PowerApps. This blog post will show you how to insert data into a Power BI dataset from Microsoft Flow.


Estimating the actual impact of an investment is an essential part of management. An investment, in this context, can be any change in resource allocation but is most often a project or marketing initiative. By quantifying the major benefits realized we obtain an objective measure of the outcome. This is useful when discussing lessons learnt and often invaluable input the next time a similar investment is considered. From a business intelligence perspective too, there is great value in comparing the actual results with the initial projection/forecast to understand limitations of existing models, and to prioritize opportunities for improvement. In addition to the aforementioned, rigorous analytics promotes a learning culture with end to end accountability. It is an essential tool for continuous improvement.



Power BI y Azure Table Storage

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

Azure Table Storage como repositorio, pros y contras!


Holiday giving by the Power BI Community

by Power BI Admin chass ‎12-13-2016 04:35 PM - edited ‎12-13-2016 09:10 PM

See how a Power BI MVP, Avi Singh gave back to the Power BI Community


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