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.
Wednesday, September 14, 2022
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
Friday, August 12, 2022
Hide or Unhide Visuals in Power BI using bookmarks
In this video we create a Power BI report and use bookmarks to Hide or unhide card visuals.
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
- Data Sets with same number of Columns
- Data Sets with different number of Columns
- Data Sets with different file types
Labels:
combine,
csv,
dashboard,
Excel,
file,
files,
multiple,
powerbi,
powerbi_training,
powerbidesktop,
powerbideveloper,
powerbiservice,
report,
sanssql,
techbytes,
transformation,
visualization,
visuals
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.
Using Custom fonts in Power BI
Saturday, July 16, 2022
Unzip and extract file contents to Power BI
This video describes how to unzip and extract file contents to Power BI. Reading zip files without extracting them.
Link to Mark's Blog: https://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
Friday, July 15, 2022
Display Alternate text when a image URL is not present in Power BI
This video describes how to display alternate text when there is no data present for the image URL in Power BI.
Labels:
Analytics,
analyticsinsight,
BI&Analytics,
image,
images,
powerbi,
powerbi_training,
sanssql,
techbytes,
visualization
Subscribe to:
Posts (Atom)