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 […]
Data Modeling
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Query Settings – Fixing a Missing File
One of the most important concepts to learn within Power BI Desktop is how to build a Data Model. Note: In simple terms the Data […]