• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • ToolBox
    • Lingo
  • Recent
  • Shop
    • Power BI SWAG
    • Scrims
    • Layouts
    • Solutions
    • DAX Games
    • My account
      • Cart
      • Checkout
    • Terms of Use
      • General Privacy Rights
      • California Privacy Rights
      • Copyright DMCA Policy
  • Clothing
  • YouTube
  • More Resources
    • MBAS 2019
    • MBAS 2018
    • Videos
  • About
    • Owners
    • Contributors
News Ticker
  • [ 2021-01-05 ] Power BI End-to-End Architecture Sharing & Administration
  • [ 2020-12-22 ] Phil Seamark on Aggregation Tables Data Preparation Tips
  • [ 2020-12-16 ] Power BI Direct Query Composite Models = Amazing Power BI Developers
  • [ 2020-12-13 ] Power BI Architecture in a Data Solution Articles & Opinions
  • [ 2020-11-18 ] Building a Power BI Admin View using Power BI APIs Power BI Developers
HomeExcel

Excel

Data Sources

Customize the Default Dataset

2020-10-22 Mike Carlo 0

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

PowerBI.Tips Tools

Monkey Tools are AWESOME

2020-08-07 Mike Carlo 0

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

AnalyzeInExcel
Power BI Developers

Analyze in Excel – the Advanced Method

2020-07-22 Steve Campbell 1

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

2020-03-23 Mike Carlo 0

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

Pareto Charts in PowerBI
Report Visualization Tips

Pareto Charting in PowerBI

2016-10-17 Mike Carlo 22

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

Load Multiple Excel Files
Data Sources

Load Multiple Excel (xls or xlsx) Files

2016-08-10 Mike Carlo 17

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

Move You Data The Easy Way
Data Preparation Tips

Using Variables for File Locations

2016-08-04 Mike Carlo 7

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

Import Excel
Data Sources

Import an Excel file into PowerBI

2016-03-29 Mike Carlo 7

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

Top Posts

  • Loading Excel Files from Sharepoint
    Loading Excel Files from Sharepoint
  • Dynamic Visuals using Buttons
    Dynamic Visuals using Buttons
  • Measures - Month to Month Percent Change
    Measures - Month to Month Percent Change
  • Icons upon Icons
    Icons upon Icons
  • Ranking Values with Measures
    Ranking Values with Measures
  • Creating A DAX Calendar
    Creating A DAX Calendar
  • Measures - Year Over Year Percent Change
    Measures - Year Over Year Percent Change
  • Loading Data From Folder
    Loading Data From Folder
  • Load Multiple Excel (xls or xlsx) Files
    Load Multiple Excel (xls or xlsx) Files
  • Measures - Dynamic Percent Change - Using DAX
    Measures - Dynamic Percent Change - Using DAX

Recent Posts

  • Power BI End-to-End Architecture
  • Phil Seamark on Aggregation Tables
  • Power BI Direct Query Composite Models = Amazing
  • Power BI Architecture in a Data Solution
  • Building a Power BI Admin View using Power BI APIs
  • Power BI Field Finder V2
  • Mirabile Notitia – Power BI with Harry Potter
  • Milwaukee Brew City PUG – Oct 2020
  • HTML Content Custom Visual
  • Power BI is part of the greater data solution
  • MVPs React October 2020
  • Customize the Default Dataset
  • Power BI Quiz – Themes
  • Milwaukee Brew City PUG – Sept 2020
  • MVPs React September 2020

Subscribe to our mailing list

Ads

Product categories

  • Game (7)
  • Layouts (22)
  • PBIX File (5)
  • Scrims (14)
  • Solution (3)
  • Uncategorized (0)

Tags

Advanced Advanced Editor Advanced Skill Level Bar Chart Beginner Beginner Skill Level Calendar CSV File Custom Layouts Custom Visuals Custom Visuals in Charts Data Modeling Dax DAX Calculate DAX Expressions DiscoverEI Excel Excel File Game Get Data ggplot2 How to Import Data from Excel Layouts mapbox Mapping Maps Measures Microsoft Milwaukee Brew City Monthly Releases MRAN Percent Change Power BI Power BI Desktop Power BI Embedded Power BI Tutorial PUG Query Settings R Slicer Tutorial Tutorials Using Data Models Videos

RSS Feed

  • RSS - Posts
Archives
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
Pages
  • About
    • Contributors
    • Owners
  • Home
  • More Resources
    • MBAS 2018
    • MBAS 2019
  • Recent
  • Shop
    • California Privacy Rights
    • Cart
    • Checkout
    • Copyright DMCA Policy
    • General Privacy Rights
    • My account
    • Terms of Use
  • Tools
    • Layouts
    • Lingo
    • Report Theme Generator V3
    • Scrims
    • Theme Generator
    • ToolBox
  • Top Tutorials
Categories
  • Articles & Opinions
  • Building Reports
  • Data Preparation Tips
  • Data Sources
  • Interesting & Fun Applications
  • News & Events
  • Performance Tips & Tricks
  • Power BI Developers
  • PowerBI.Tips Tools
  • Report Data Tips
  • Report Interactions
  • Report Visualization Tips
  • Sharing & Administration

Copyright © 2021 | MH Magazine WordPress Theme by MH Themes