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 […]
Excel
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 […]
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. […]
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 […]
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 […]
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 […]