Power BI

One of the most common types of banding or binning is banding based on a range. Let's say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping…

This will show you how to use a DateKey or Date column to incrementally refresh your Power BI dataset which improves refresh performance

9 PowerBI tips to help you manage and perfect your PowerBI, DAX and analysis skills.

Learn to configure your Power BI Aggregations table to really increase the speed of your DAX queries. This does NOT require Power BI Premium!

<p>We have great updates this month! We are releasing new button actions, multi-column sort for tables, dual axis for line chart, a search for the filter pane, updates to decomposition tree, and much more! We are also releasing a preview of an enhanced dataset metadata feature, which will be foundational for XMLA read/write and for management of Power BI dataset and the migration of Analysis Services workloads to Power BI.<br /> Check out the full blog to learn more about all the updates and enhancements this month.</p>

Explore the options when implementing Row Level Security in your tabular model.

<p>Today, I’m excited to announce that we’re releasing a new, revamped search experience that allows users to search across all the content they have access to from any page in the product! </p>

Showing how the use of the Aprrox Distinct Count is a lot faster than using the DISTINCTCOUNT that is native to DAX measures.

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various &#…

Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in or…

Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user …

<p>We are thrilled to announce an additional layer of capabilities, allowing you to export a Power BI report by using a REST call, to the following file formats: PDF, PPTX (PowerPoint) and PNG. </p>

Reading Time: 4 minutes Power BI buttons provide more interactivity in reports, and different states allow unique formatting when users interact with a button. What are the visual icons available when using buttons in Power BI, and is it possible to extend them? Button Icons Power BI has a handful of button icons that provide cues for user interactions.…

Much has been said about DAX, and even more will be told, as DAX still evolves and the adoption of tools that are using DAX like Power BI and MSFT Analysis Services Tabular is growing. This series of blog posts are inspired by questions asked on https://community.powerbi.com. These questions are touching the most foundational concepts and are reminding me of my journey into the realm of evaluation context, filter propagation, data lineage, the scope of variables, and the mysterious world of table iterators, just to name some concepts. Sometimes it seems that these foundational concepts are ...

Introducing Interactions Setting, which lets you configure how to interact with reports in Power BI mobile apps. Including docking report footer and enabling multi-select!

This article discusses how to scrape data from dynamic websites that reveal tabulated data through a JavaScript instance.

Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only seem incorrect because an incorrect assumption might have been made. Let's dive into the issue with an example. The Problem Suppose we have employees entering timesheet da

This article describes how to implement currency conversion for reporting purposes in Power BI. Currency conversion applied to reporting can include many di

One of the interesting calculation challenges in BI systems is a segmentation or grouping on a numeric value, based on an occurrence of another value. As an example; You might want to know How many customers ordered once, twice, three times or more. The challenge is that the data in the transactional table is not…

In the previous part of this article, I explained what is the segmentation challenge, when you want to group data based on the aggregated result, and I explained a static method of creating aggregated tables and creating a relationship to the main detailed table. However, the caveat of that method is the segmentation is done…

Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table.…

The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can…

Today, I’m excited to announce that we’re introducing Featured content on Power BI Home. Now, administrators or designated promoters will have a dedicated section on Home to promote reports, dashboards, and apps and set the default recommended content for their end users.

Back in December when I wrote a series of posts on testing the performance of Power BI reports in the browser, I mentioned that it was important to test in the browser because some aspects of the p…

A quick point: while the Power Query Query Diagnostics functionality is relatively new, it’s based on Power BI/Power Query trace logging that has been around for a while. I’ve just real…