In this blog let's take a look at how you can Fill blank cells with values before or after them also know as Fill Up or Fill Down in various tools.

In this blog let's take a look at how to split multiple columns with concatenated strings into rows in PowerQuery, we will write M code...

DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...

As the title says how do you really do it? Because you can go from DirectQuery <> Dual > Import but you can't go from Import to Dual or...

DAX doesn't have the concept of global variables so reusing a piece of code by referencing it somewhere else isn't possible, luckily the...

As the title suggest let's see how to move (technically recreate) a PBI dataset in PBI service into a different workspace, the gist of...

In this blog I want to show how you can load the Tabular DLL to connect Python with Power BI, SSAS, or PBI Service. I am going to refer...

In this post let's take a look at how to convert a text string such as 2h15m8s to 135.13 minutes This is the table that we are working...

In this blog let's take a look at how you can use Python to export users across all workspaces in Power BI Service into an Excel file....

While working with DAX, a common mistake that anyone makes (that I also made) is to think that applying a filter on a column of a...

One thing that we are used to is ALL functions ignore filters and return either a unique value or complete table when used as a table...

Power BI Service allows you to refresh your model completely but sometimes that's not what you want specifically when you are making...

Here is PowerShell script that adds a particular user or a group to all the workspaces in a tenant. The Where-Object method filters the...

I was looking for a good week based date table on Internet and found only 1-2 but I didn't find columns that I needed, so my search ended...

Model.bim is a JSON file which is the skeleton of your Power BI or SSAS Model, using this file you can create a database from scratch,...

Someone asked on Power BI Service on how to get all reports across all Premium workspaces so I started reading documentation and found...

In this blog let's take a look at the performance of a report when you use a Measure in the Filter Pane. Let's say you have a data model...

Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...

DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...

In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...

In this blog lets see how we can implement OLS or Object Level Security in Power BI. In simple terms the difference between RLS and OLS...

A very common scenario in Power BI is of extracting measure into text file and then loading them back again in the Power BI file so that...

TE3 is the ultimate development tool for creating Tabular Model and recently I got an opportunity to make a full fledged course on it for...

In this blog let's see how we can combine Stored Procedure and Parameters to load data into PBI. First we need to create a very basic...