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.

How to enable Excel Pro’s to use Power BI Datasets

by guavaq Super Contributor on ‎12-07-2017 07:42 PM - last edited on ‎12-08-2017 04:50 PM by Power BI Admin MindyJ

In the steps below, I will demonstrate how to access your Power BI Dataset through Excel. This is a great example for people who love Excel and use it as their tool of choice, but the company or organization still wants to have a single version of the data. By leveraging the steps below the data is available in the Power BI Service, as well as from Excel. NOTE: This currently only works on a PC.


In this blog post we will take a look at how to automate the process of updating the data in the Power BI report we created in part 2, without needing a computer or server. We will do this by scheduling a Runbook in Azure Automation.


Power BI Group management using Active Directory roles and PowerShell

by NormYoung Frequent Visitor on ‎11-21-2017 10:49 AM - last edited on ‎11-28-2017 10:50 AM by Power BI Admin MindyJ

Use PowerShell to maintain Power BI / Office 365 Groups. 


Integrating PowerShell with PowerBI: Module, script and reporting (Part 2)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:41 AM - last edited on ‎12-06-2017 03:43 PM by Power BI Admin MindyJ

In my last blog post, Integrating PowerShell with Power BI (Part 1), I set up the connection between Power BI and PowerShell.  If you followed the steps in part one, you are set to start using this newly created integration.  In this post I will take a look at how we use the Power BI module and how to visualize the data in Power BI reports.


Integrating PowerShell with Power BI (Part 1)

by AlexHolmeset Frequent Visitor on ‎11-21-2017 02:27 AM - last edited on ‎12-06-2017 03:40 PM by Power BI Admin MindyJ

Power BI is an extremely powerful data and visualization tool. It has opened a new world for me. But, the first thing I always think about when looking at Microsoft products is that there must be a way to control this with PowerShell. I did not find any useful information about any PowerShell module on the product pages.  After some googling, I found a module on the PowerShell gallery potentially created by a Microsoft employee.  What's surprising is that the module has been out for about 7 months and has barely 130 downloads.  Why hasn’t this been more popular? Hopefully I can help change this with a series of blog posts looking at the possibilities of Power BI and PowerShell.


Help creating your JSON file template for themes using a Power BI file

by ruthpozuelo Regular Visitor on ‎11-14-2017 09:20 AM - last edited on ‎11-17-2017 08:28 AM by Power BI Admin mbenjamin


Have you tried to create a JSON file to manage the theme on your Power BI report? Not an easy task, right? I tried to do this last week, and I found it hard and confusing. Hours went by, and I was almost in the same place as when I started. My method was obviously not working, and the available documentation was not clear for me. I needed to do something else if I was going to produce a JSON file theme for my customer.  So, what to do? I use Power BI for everything, ok not everything, but almost everything. So, I used Power BI to create a documentation that I could understand, and finally my JSON file was done (or at least I did all that could be done, more on that on the later).


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.


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.


How to use your Office Theme as Power BI Report Theme

by DominikPetri Regular Visitor on ‎07-12-2017 01:10 PM - last edited on ‎10-24-2017 09:41 AM by Power BI Admin mbenjamin

Since Power BI Desktop’s March 2017 Update, it is possible to apply a color theme to your entire report. When you apply a so called “Report Theme”, all visuals in your report use the colors from your selected theme. Unfortunately, you can’t just import your Office Theme Colors into Power BI Desktop since they have different structures and filetypes. Therefore, I developed an Excel tool (the download link is at the end of the article) that converts your Office Theme into a Power BI Desktop Theme in 4 simple steps.


Excel tool to convert an Office Theme into an Power BI Desktop ThemeExcel tool to convert an Office Theme into an Power BI Desktop Theme


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.


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


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.


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


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.



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. 


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


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.


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!  


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.


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 Jessica Regular Visitor

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!


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


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.