SansSQL

Wednesday, September 14, 2022

Replace nulls with zeros in Power BI

This video demonstrates on how we can relace a specific value with another value. One such case explained in this video is on how we can replace nulls with zeros. 

Sunday, August 28, 2022

Connect to MySQL DB | This connector requires one or more additional components to be installed

This video describes how to connect to MySQL Database and fix an common issues with the Power BI MySQL connector  which says "This connector requires one or more additional components to be installed". 

Download link to MySQL NET Connector

Tuesday, August 9, 2022

Combine Multiple files and load to Power BI

In this video we discuss on how we can combine multiple files and load into Power BI. For the demo, we have the following 3 scenarios

  1. Data Sets with same number of Columns
  2. Data Sets with different number of Columns
  3. Data Sets with different file types

Friday, August 5, 2022

Power BI Content Sharing - Who can see what


This video explains on who can see what content when Power BI content is created or shared across the license types.

Ads