Power BI

Video by: Reid Havens Learn how to display DAX expressions in the description tooltip - when hovering over the measure in the fields list. This can be applied to all measures easily and effortlessly using Tabular Editor . Related Content External Tool - Tabular Editor External Tool

Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team's product group and community experts and MVPs from all around...

Learn how to change the data source type of a Power BI report dynamically using Power Query parameters in a step by step guide.

About a couple of years ago, I wrote two articles about what is association rules and how we can have them in Power BI.In this post, I am going to put some more enhancements and show you how with data that is not cleaned how you can create Market Basket Analysis. these enhancements are about Read more about Market Basket Analysis in R Part 3[…]

I show in this blog post how to connect to a Power BI Premium Per user dataset with SQL Server Management Studio.

We’re pre-announcing a new capability to help organizations automatically install the Power BI app for Microsoft Teams for active users of the Power BI service. A new Power BI admin tenant setting is starting to roll-out allowing Power BI admins to control automatic installation. Automatic installation will start occurring in November 2021 for organizations with the setting enabled.

The script for a Power Query function that can be used easily to generate the column value distribution to be used in Power BI.

When you use a measure as a filter in a Power BI visual, the DAX code generated might show a different behavior whether the measure is part of the values sh

Design your own Custom KPI Card in Power BI. Use these ideas to build your own professional looking reports.

Learn how to add targets to your KPI's for different countries by setting up the correct relationship in the modelling tab.

Variables can simplify your DAX code, help with debugging and help improve performance. To use variables in your DAX measure you need to declare a variable using the VAR keyword, give the variable a name, and then assign an expression to the variable. You can use multiple variables in a measure but when using variables […]

Using PowerBI Dataflow to share data between departments is increasingly getting more popular, with the rise of managed self service offering, it is not unusual to find a non centralised Data wareh…

My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ori…

Introduction OK, so as I mentioned in Part 1, a user in my user group recently asked me about localizing a Power BI data model including table names, column names, measure names as well as titles for visualization, etc. I figured I'd break this subject up into chunks so there will at least be two pa...

One of the most challenging aspects of developing your own application is adding reporting capabilities. Power BI Embedded gives you the ability to include the capabilities of Power BI while hosting the reports in your application.  This post provides a curated resource guide.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - Power BI can become a closed garden for Excel users, but what if we use WorkFlows to expose the data?

Brand new External Tool to copy the Server and Port number directly from Power BI Desktop. Read the full article to get the new tool.

There are some cases that we want to add a leading zero to a digit, such as showing 01 instead of 1, 02 instead of 2 and so on. We have two options to do this in Power BI, doing it in Power Query or doing it with DAX. Adding a Leading Zero in Power … Continue reading Quick Tips: Adding Leading Zero to Integer Values (Padding) with DAX and Power Query

Learn how to create a report of column's value distribution in Power BI report using Power Query techniques and enhance data profiling.

Our upcoming State and Local Power BI Community Call will focus on administrative scripts that can be used for lightweight management of your Power BI environment. This will be a script heavy session …

Usage scenarios: Sample data table:   #1. Check field if they existed English characters.(upper: 65 ~ 90, lower: 97 ~ 122)   Create a list of all English characters. List.Transform(List.Union({{65..90},{97..122}}),each Character.FromNumber(_))​ Add a custom column with function to compare each cha...

Standard Bank, which operates in more than 20 countries in sub-Saharan Africa and abroad, adopted a self-service Power BI model in 2017 and has evolved the platform from descriptive analytics to predictive and prescriptive models. The bank’s Insurance Business group collaborated with its BI Data Visualization team to use AI and automated machine learning to predict and accurately target customers.

I’m happy to update that during September we are modifying the preview release, specifically lifting the 50 exports per hour per capacity limit. More details inside.

Earlier this week I did a live stream event.  I put out a poll and asked people to tell me what topic they wanted me to talk about.  The options were Calculated Columns vs Measures Tips for Excel users moving to Power BI Using Variables in your DAX The overwhelming [...]Read More »

Here is how to create a Power BI chart with an accented gap between two lines. It will help you evaluate the difference between two values.

Find out which visuals in your Power BI report generated a given DAX query