• Home
  • Tools
    • Business Ops
    • Themes – New
    • Scrims
    • No Code – Custom Visuals
    • Layouts
    • Custom Visuals Gallery
    • Connections (PBIDS Files)
    • Model.JSON builder
    • 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
  • Podcast
  • About
    • Owners
    • Contributors
  • Training
News Ticker
  • [ 2022-11-03 ] Welcome to Community Jam Articles & Opinions
  • [ 2022-10-12 ] Live AMA with Marco Russo & Alberto Ferrari News & Events
  • [ 2022-09-20 ] Super Fast Data Loads to Prod Sharing & Administration
  • [ 2022-05-06 ] Power BI Hack: Download Report Authored in Browser as PBIX Sharing & Administration
  • [ 2022-04-30 ] Power BI Support Channel: Microsoft Teams Tips Sharing & Administration
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 […]

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 © 2023 | MH Magazine WordPress Theme by MH Themes