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.

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

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

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

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

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.

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

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

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

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.

Read more...

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!

Read more...

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.

Read more...

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.

Read more...

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.

Read more...

Attachment

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

Managing Complexity

by Christian_Berg Visitor on ‎12-05-2016 10:28 AM

In part one, we considered how correlation plots can easily be integrated in Power BI reports to show how various factors relate to one another. That has been a useful starting point for me when looking at new data for the first time. Unfortunately, the world is often more complicated than that. For instance, revenue and inventory may be positively correlated during the high season but negatively correlated during the other months of the year (if a lack of stock hurts sales). A simple correlation plot would not be able to show that. In this post, we will therefore look at a simple approach to detect simultaneous interactions between multiple variables.

Read more...

Attachment

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

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

Revenue and forecasting

by Christian_Berg Visitor ‎11-04-2016 11:33 AM - edited ‎11-04-2016 11:33 AM

Forecasting is an important part of most management positions. Knowing how many products will sell where and when, informs resource decisions like staffing and inventory. It is also an intuitive way to compare performance between different business units, product categories etc. For P&L owners it is an essential tool to proactively manage their margin by adapting investment levels.

Read more...

Attachment

This article describes the approaches that can be used to connect Power BI to on premise data.  The impact of using the Power BI model, DirectQuery and LiveConnection are explored as well.

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

Reviewing individual business units and benchmarking them against one another is an important process to verify that investment levels are still appropriate. Working as a business controller I frequently facilitated management reviews. The goal then was to assess if teams had the appropriate amounts of resources. A business that was underperforming and that saw few growth opportunities might find their resources reallocated whilst a high growth area might have a business case for incremental investments. To normalize for variations growth potential and risk various techniques were used. An internal finance function might develop this point of reference in the form of a forecast or “budget”.

Read more...

Attachment

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

Strategic decisions support through business driver analysis

by Christian_Berg Visitor on ‎10-17-2016 11:04 AM - last edited on ‎10-17-2016 11:49 AM by Power BI Admin Jessica

Having interviewed and worked with hundreds of business analysts and P&L owners, I am impressed by the capacity of human intuition. People who have been in role for more than a couple of years can often balance multiple complex considerations and quickly make a good decision. This frees up time for the employee. Unfortunately, this spare time is more often used to increase the frequency at which they look at the standard reports, rather than deep analysis to try and challenge their already impressive understanding of the business. A common problem with this is confirmation bias and existing misunderstandings of true drivers can persist or a change in underlying fundamental is overlooked. In the next couple of posts, I will share techniques that I have seen successfully employed to counter common heuristics and to increase the chance of continuous improvement.

Read more...

Attachment

Become your organization’s strategic advisor by using Machine Learning and Power BI

by Christian_Berg Visitor on ‎10-17-2016 11:03 AM - last edited on ‎01-04-2017 10:32 AM by Power BI Admin Jessica

In this series of blog posts, I will provide a step by step guide on how to become the change agent that puts your organization on a path towards continuous improvement using the most valuable decision support techniques.

Read more...

We want to hear what's got you thinking about Power BI and Business Intelligence, from opinion pieces on the latest industry trends, to helpful tips and how-tos for your fellow Power BI users, to "trip reports" from your local User Group meeting or Microsoft event. 

Read more...