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
- Mar 11
- 2 min
Add or Remove a User or Group from all Workspaces in Power BI Service
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...
8440
Antriksh Sharma
- Mar 3
- 2 min
Export Measures from Power BI using C#
Here is a code that exports measures from Power BI Desktop, Power BI Service, or Analysis Services Tabular On Premise using C#. //...
3190
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 29
- 4 min
Create SSAS Tabular and Power BI Dataset with Python from Model.bim
In this blog let's take a look at how you can use the Model.bim file extracted either from SSAS Tabular, Power BI Desktop or Power BI...
1,1290
Antriksh Sharma
- Jan 21
- 2 min
Publish Power BI reports using PowerShell Cmdlet
As the title suggest let's see how to publish multiple reports to Power BI Service with PowerShell. First order of buisness is to ensure...
1520
Antriksh Sharma
- Jan 16
- 1 min
Loop over YouTube playlists with Python and get video title, likes, views, and duration.
Here is a Python script that allows iterates over a YouTube playlists. The current limitation is that I have to prepare a dictionary with...
2860
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
- Oct 31, 2022
- 3 min
How to make Power Query remember the data types of columns before expanding.
A common issue that I have faced consistenly is that when expanding columns that contains tables in Power Query the data types of the new...
6510
Antriksh Sharma
- Oct 24, 2022
- 2 min
Get all Reports from Power BI Service using Rest API and PowerShell
Someone asked on Power BI Service on how to get all reports across all Premium workspaces so I started reading documentation and found...
9120
Antriksh Sharma
- Sep 6, 2022
- 4 min
How many queries can Power BI engines cache?
If you work with Power BI and SSAS Tabular one thing to know is that there are 2 engines in Analysis Services i.e. Formula & Storage...
2820
Antriksh Sharma
- Jul 8, 2022
- 3 min
Performance penalty of Measures in Filters Pane in Power BI
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...
8852
Antriksh Sharma
- Apr 29, 2022
- 3 min
Complex behaviour of slicers in Power BI
Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...
5670
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
- Feb 24, 2022
- 3 min
Using Python to Execute DAX Queries in Power BI & SSAS Tabular - Part 1
In this blog let's take a look at how you can use Python to connect to either Power BI or SQL Server Analysis Services to run DAX...
7,2491
bottom of page