DAX | Power BI | Power Query | Excel | VBA | Antmanbi.com

Fixing Lineage issue when JOIN-ing tables in DAX

Nov 212 min read

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...

Antriksh Sharma

Oct 193 min read

Why DAX is returning 100%

In this blog let's take a look at why your DAX calculations are returning 100% instead of a fraction of the grand total. In DAX you can...

Understanding how Time Intelligence functions are evaluated in Row Context

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...

Change storage mode of a Table in Power BI

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...

Using DETAILROWS with WINDOW functions in DAX

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...

Move Power BI Datasets to different workspace with Python

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...

Create Partitions in SSAS Tabular with Tabular Editor

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...

One problem with Power BI Project files and Git integration

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...

Installing TOM Library to connect Python to Power BI & SSAS

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...

Convert Hour Minute Seconds text to Minutes in Power Query

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...

Export users in Power BI Workspaces with Python and REST API

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....

Applying a Filter on Dimension vs Fact in DAX

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...

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...

Refresh Individual Power BI Tables or Partitions with PowerShell

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...

Add or Remove a User or Group from all Workspaces in Power BI Service

Antriksh Sharma

Mar 11, 20232 min read

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...

Antriksh Sharma

Mar 3, 20232 min read

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#. //...

445, 454, or 544 Week table in Power BI and Excel

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...

Extract model.bim file from Power BI & SSAS Tabular with Python

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,...

Create SSAS Tabular and Power BI Dataset with Python from Model.bim

Antriksh Sharma

Jan 29, 20234 min read

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...

Publish Power BI reports using PowerShell Cmdlet

Antriksh Sharma

Jan 21, 20232 min read

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...

Loop over YouTube playlists with Python and get video title, likes, views, and duration.

Antriksh Sharma

Jan 16, 20231 min read

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...

Generate custom Contoso Database for SQL Server by SQLBI - ELI5

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...

How to make Power Query remember the data types of columns before expanding.

Antriksh Sharma

Oct 31, 20223 min read

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...

Get all Reports from Power BI Service using Rest API and PowerShell

Antriksh Sharma

Oct 24, 20222 min read

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...

www.antmanbi.com