Power BI

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

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.

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 »

The simple and easy to build and design reports in Microsoft Power BI.

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.

Sample Table In the following scenario, I would like to insert a sum row for each 5 days as an example.   Method 1      let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBLCsAgDATQu7iWkon1dxbx/tdoAqWQjrh7yiTjWklFcdlJOUEk7fyRGtUgxaQHuU1GkGrSgjR60yl5+HgEmhRk9/8k+N4z...

When you are new to use the relative time filter and relative time slicer in a report, you might find that the filtered records are not consistent with that you observe the results manually. For example, I have some ticket data as below. I hope to see the records created in the last 12 hours of the ...

I created a video to demonstrate how you can highlight any time-bound events on a chart timeline using DAX and conditional formatting in Power BI.  In addition, in this example, we will analyze and visualize how events like Covid lockdown, promotions, and campaigns can impact sales performance. You ...

Today we are happy to announce public preview of default label policies in Power BI Desktop and call out significant features that address top asks for Power BI information protection released in the last few weeks.

Learn how to secure report pages or tabs in Power BI from unauthorized access and control who has access to what page.

A very common requirement for a Power BI report that I stumble across at almost all of my customers is to automatically show data for the current day/month/year when a report is opened. At first sight this seems like a very trivial problem but once you dig into the problem, you will realize that all…

In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]