Data Sources
Customize the Default Dataset
In the October 2020 release of Power BI desktop you have the ability to load a dataset from the splash page. For this tutorial we dig in on how Microsoft enables a default dataset. Additionally […]
Data Modeling
Power BI Developers
Tabular Editor Rocks!
Tabular Editor is an incredible Tool that enables users to manipulate a Tabular model at lighting speeds. Daniel Otykier is the creator of the Tabular Editor program. We are producing a video series to enable […]
Interesting & Fun Applications
Temple of DAX – 3D
To celebrate joining the Power BI Cat team next week, I thought I would update a DAX game I built last November (2018) which was a DAX-based maze game in Power BI that allowed you […]
Data Preparation Tips
Adding Data Types Within Query Editor
If you have spent any time working in Power BI, your very first step is to, wait for it… Get Data. Using Get Data will start loading your data into the Query Editor for Extracting, […]
Data Sources
Get Your OData Here
For those of you who are following my tutorials, you are most likely to understand that each tutorial comes with it’s own data source. This has been intentional so we can both walk through the […]
Data Sources
Load Multiple Excel (xls or xlsx) Files
Previously we’ve done a tutorial on loading multiple text files within one query. This is nice, however we will also need to import multiple Excel files. First, to understand the procedure of querying multiple excel […]
Data Preparation Tips
Using Variables for File Locations
This week I encountered an issue when working with multiple queries in my data model. Here is the source files in case you want to follow along. Here’s what happened. I had a PBIX file […]
Data Sources
Loading Data From Folder
Let me setup a scenario for you. You get a data file from an automated system, it has the same number of columns but the data changes for every new file. Being the data savvy […]
Data Preparation Tips
Query Editor – Editing M Code
In this tutorial we’ll learn how to copy and paste queries to and from the Query Editor. When your working in Power BI Desktop often you will need to share and model the data before […]
Report Data Tips
Measures – Calculating a Sum
Often there are times when you will want to display a totals. Using measures to calculate a total are extremely easy to use. The power of using a measure is when you are slicing and […]