Power BI | antmanbi

Nov 21, 20242 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...

Apr 30, 20242 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...

Apr 13, 20244 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...

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

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

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

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

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

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

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

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

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

www.antmanbi.com