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 […]
Excel
PowerBI.Tips Tools
Monkey Tools are AWESOME
The Monkey Tools add-in for excel is really amazing. As a developer for Power BI for many years I’ve learn a ton of tips and tricks while working with Power Query. Watching Ken demo the […]
Power BI Developers
Analyze in Excel – the Advanced Method
A common ask from users is the ability to view data related to visuals in excel. While there is an option to export data, the format is often unfriendly and has limitations. What’s more, this […]
Building Reports
Milwaukee Brew City PUG – Feb 2020
The Milwaukee Brew City PUG for February had tons of rich demo content. Steve Campbell delivered quite a session for an hour and a half. We were able to record this session and are happy […]
Report Visualization Tips
Pareto Charting in PowerBI
The Pareto chart is a handy visual, but is not so easy to build in either excel or PowerBI. In a Pareto chart, information is provided about an individual product or category as a bar, and […]
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
Import an Excel file into PowerBI
We are going to kick this blog off with a simple example of how to load data from excel into Power BI Desktop. Note: I’m a firm believer of always understanding your data. If you […]