Fixing Lineage issue when JOIN-ing tables in DAX
DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
May 168 min read
Understanding how Time Intelligence functions are evaluated in Row Context
I have been thinking about this for a while, a series of blogs where I try to explain how a particular piece of DAX code works. For this...
8781
Antriksh Sharma
Apr 302 min read
Change storage mode of a Table in Power BI
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...
3100
Antriksh Sharma
Apr 134 min read
Using DETAILROWS with WINDOW functions in DAX
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...
1,5891
Antriksh Sharma
Oct 28, 20233 min read
Move Power BI Datasets to different workspace with Python
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...
7530
Antriksh Sharma
Aug 22, 20233 min read
Create Partitions in SSAS Tabular with Tabular Editor
In this blog let's see how to create Partitions in SSAS Tabular with the help of Tabular Editor, I am using TE3 as it works best when...
1,3461
Antriksh Sharma
Aug 10, 20232 min read
One problem with Power BI Project files and Git integration
UPDATE: saving metadata as TMDL format now allows easy merging. Power BI's June 2023 update introduced a feature that allows you to...
8620
Antriksh Sharma
Jun 28, 20232 min read
Installing TOM Library to connect Python to Power BI & SSAS
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...
1,8050
Antriksh Sharma
Jun 12, 20232 min read
Convert Hour Minute Seconds text to Minutes in Power Query
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...
7430
Antriksh Sharma
May 16, 20233 min read
Export users in Power BI Workspaces with Python and REST API
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....
9010
Antriksh Sharma
May 10, 20234 min read
Applying a Filter on Dimension vs Fact in DAX
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...
3,2490
Antriksh Sharma
Apr 28, 20231 min read
ALL Functions vs Security in DAX
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...
3790
Antriksh Sharma
Apr 3, 20234 min read
Refresh Individual Power BI Tables or Partitions with PowerShell
Power BI Service allows you to refresh your model completely but sometimes that's not what you want specifically when you are making...
1,8670
Antriksh Sharma
Feb 16, 20231 min read
445, 454, or 544 Week table in Power BI and Excel
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...
4370
Antriksh Sharma
Feb 5, 20233 min read
Extract model.bim file from Power BI & SSAS Tabular with Python
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,...
2,8031
Antriksh Sharma
Jan 8, 20233 min read
Generate custom Contoso Database for SQL Server by SQLBI - ELI5
I this blog I want to show how you can use the Contoso Generator from SQLBI - Contoso Data Generator There are quite a few options that...
7302
Antriksh Sharma
Mar 28, 20225 min read
Full Outer Join in DAX in Power BI and SSAS Tabular
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...
3,4460
Antriksh Sharma
Mar 10, 20227 min read
Getting started with Aggregations in Power BI - Part 1
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...
6050
Antriksh Sharma
Dec 20, 20212 min read
Storing a column as String or Integer in Analysis Services
Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this...
4820
Antriksh Sharma
Nov 18, 20214 min read
Dependency of a function on Row Context in DAX
Have you ever writen a piece of DAX Code that looks like this: and ended up confused how is it able to calculate how many years, days,...
6290
Antriksh Sharma
Sep 26, 20213 min read
How to extract measures from Power BI to Excel or Text file?
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...
5,1991
Antriksh Sharma
Sep 16, 20211 min read
Tabular Editor 3 Course
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...
1230
Antriksh Sharma
Sep 3, 20211 min read
How To Load Data In Power BI With Stored Procedure and Parameters
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...
4,6500
Antriksh Sharma
Aug 3, 20212 min read
Previous Year calculation in case of missing years in DAX.
One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...
1,0700
bottom of page