Antriksh Sharma
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...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
- Aug 10
- 1 min
One problem with Power BI Project files and Git integration
Power BI's June 2023 update introduced a feature that allows you to separate different objects of the PBIX into Reports, Dataset,...
3970
Antriksh Sharma
- Jun 28
- 2 min
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...
4950
Antriksh Sharma
- Jun 12
- 2 min
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...
2320
Antriksh Sharma
- May 16
- 3 min
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....
4220
Antriksh Sharma
- May 10
- 4 min
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...
1,3410
Antriksh Sharma
- Apr 28
- 1 min
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...
2180
Antriksh Sharma
- Apr 3
- 4 min
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...
7650
Antriksh Sharma
- Feb 16
- 1 min
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...
2620
Antriksh Sharma
- Feb 5
- 3 min
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,...
4730
Antriksh Sharma
- Jan 8
- 3 min
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...
2830
Antriksh Sharma
- Mar 28, 2022
- 5 min
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...
1,9590
Antriksh Sharma
- Mar 10, 2022
- 7 min
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...
3640
Antriksh Sharma
- Dec 20, 2021
- 2 min
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...
3510
Antriksh Sharma
- Nov 18, 2021
- 4 min
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,...
5380
Antriksh Sharma
- Sep 26, 2021
- 3 min
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...
2,1800
Antriksh Sharma
- Sep 16, 2021
- 1 min
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...
830
Antriksh Sharma
- Sep 3, 2021
- 1 min
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...
1,9660
Antriksh Sharma
- Aug 3, 2021
- 2 min
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...
6450
Antriksh Sharma
- Jul 23, 2021
- 2 min
How to Load Data From Power BI into SQL Server?
Whenever I work with LinkedIn data challenges a very common task for me is to load data into SQL Server as modifying the data in SQL is...
6120
Antriksh Sharma
- Jul 12, 2021
- 4 min
How to create Running Total in Power BI: The Basics
In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...
4,3750
Antriksh Sharma
- Jul 1, 2021
- 2 min
Dynamically Remove Null Columns in Power Query with M code
I was recently working with a dataset and found that there were a lot of columns that were completely null, now going 1 by 1 through each...
3,5371
Antriksh Sharma
- Jun 24, 2021
- 1 min
Create relationships in Power BI with Tabular Editor
Creating relationships in Power BI is as simple as it can get but to be able to edit/create relationships in Power BI with TE is...
1,4411
Antriksh Sharma
- Jun 17, 2021
- 1 min
Dynamically change column names in Power Query using predefined values
In Power Query if you want to change names of columns you can easily do so by going through each column one by one and then renaming...
4100
bottom of page