Power BI

BigQuery team recently released a fantastic new functionality, when using BI engine, all the statistics are saved in the INFORMATION_SCHEMA. When using BI Engine one major pain was it was not very …

I’ve come across many charts like this in the wild. They’re not bad charts, they serve a purpose, but they could be better.  Bar charts are created by encoding data by length. It is commonly thought that when people read bars, they are comparing length, not position. The axis starts at 50%, rather than zero,… Continue reading Thinking about target bands

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow…

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script! Delete Group/Workspace API: https://docs.microsoft.com/rest/api/power-bi/groups/delete-group AddUserAsAdmin API https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin Power BI PowerShell CMDLETs https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps PowerShell Script: https://github.com/itsnotaboutthecell/PowerBI-cmdlets/blob/master/notebooks/PowerBI_Delete_Orphan_WS.ps1

In this session, Krish will show you how you can use Power BI to easily create 'real' real-time scenarios using Streaming Dataflows.

How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle? Check how Calculation Groups can help you to achieve (im)possible!

Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! –This Year let Source = Sql.Databases(“servername”), AdventureWorksDW = Source{[Name=”databasename”]}[Data], internetsales = AdventureWorksDW{[Schema=”dbo”,Item=”pbi_InternetSales”]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear –Last […]

If you are looking for the conditional formatting in the new #PowerBI formatting pane, I show you where to find it!

Switch Power BI chart axis dimensions to get data grouped by dates, weeks, months, or any other way that you want.

How many ways there are to create a Year-Month column in DAX? In this blog post, I'll show you one bad way, one OK way, one good, and one great way.

Here we’ll lay out a common framework (which we’ll refer to as “C-Frame”) for managing Power Platform solution development. This approach is best suited for solutions that classify as important or critical according to the Environmental Architecture Model found in the Power Platform Adoption Framewo

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values. The IN oper

It is a quick Hack and maybe useful, let’s say you want to keep a snapshot of a previous data, for example you have a dimension table and you want to see how the data has changed between mult…

Here is how to calculate weighted average using DAX in Power BI. By using that, you can get results by necessary category.

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are …

One of the questions that I’ve been asked consistently over the past...

A Center of Excellence can be tool or topic-specific. In this blog, we apply a CoE framework to focus on Power BI and collaboration in an organization.

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

My go to progress dashboard calculates a lot of progress % metrics and graphs. However for larger projects, its often difficult to zoom into the graph. This is exactly why slicers exist

Few ways to get relative & abolsute refresh durations in Power BI

Our Power BI Principal Consultant Kane Snyder shares some tips and techniques on how to combine static and dynamic filters in a slicer

This post explains how to build a multiple measure selector in chart, so that only part of the measures are displayed. A calculation group makes it possible.

Discover how Microsoft created new training methods on analyzing data with Microsoft Power BI to help them make data-driven decisions.

The concept of extended tables is at the core of the query performance of Power BI datasets, but it is often overlooked. This article will hopefully change this.

Microsoft’s drive to make more and better data-driven decisions is fueled by analyzing data with Microsoft Power BI.But how is it getting employees to analyze their data and build their own …

In this digital age, data is a strategic asset, and creating a modern data catalog is key to finding and connecting siloed enterprise data, which enables people to ask important questions and gain business insights. Microsoft used feedback from end users to develop an intuitive data catalog that incorporates discoverability, traceability, and access management. To gain adoption for the catalog, the team generated excitement through a structured marketing campaign that used internal social channels, posters and digital signage.