DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...

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

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

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

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

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

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

UPDATE: saving metadata as TMDL format now allows easy merging. Power BI's June 2023 update introduced a feature that allows you to...

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

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

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

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

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

Power BI Service allows you to refresh your model completely but sometimes that's not what you want specifically when you are making...

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

Here is a code that exports measures from Power BI Desktop, Power BI Service, or Analysis Services Tabular On Premise using C#. //...

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

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

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

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

Here is a Python script that allows iterates over a YouTube playlists. The current limitation is that I have to prepare a dictionary with...

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

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

Someone asked on Power BI Service on how to get all reports across all Premium workspaces so I started reading documentation and found...