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...
top of page
Power BI | Excel | Python | SQL
Search
Antriksh Sharma
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...
3,4980
Antriksh Sharma
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...
6100
Antriksh Sharma
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...
4,6780
Antriksh Sharma
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...
6961
bottom of page