SQL

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

Mar 28, 20225 min read

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

Mar 10, 20227 min read

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

Sep 3, 20211 min read

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

May 7, 20211 min read

SQL to DAX: Select/Project Columns

In this blog let's understand the difference between selecting columns in SQL vs DAX, i am using a fairly simple Product table which...

www.antmanbi.com