In this post we will explore how to make the Sample Binary file path dynamic when combining files using the new Combine Binaries experience in Excel and Power BI Desktop. Sample Files If you'd like some sample data files to
If you've wanted to use Power Query to combine Excel files with a single click - like you could for TXT and CSV files - the feature is finally here*. The Combine Binaries feature has been re-written (as I discussed
One of the updates in the latest Excel 2016 Insider preview build is a new Combine Binaries experience for Power Query. This is both good and bad, and in this post we'll take a detailed look at both sides before
The November 2016 update is now out and it finally brings a way to view the Power Query dependencies viewer. While it’s been out in Power BI Desktop for a while, (as Matt posted about a while ago,) this is
More and more I’m seeing examples where people are trying to extract data from a mixed column. In other words, they have two data types in a single column, but need to find a way to extract one from the
Have you ever set up a nice query to UnPivot other columns, only to find that the query data types change when you add new columns? This post will cover why values become text after unpivoting other columns. Background We’ve
It’s been a few weeks since I’ve posted a technical blog post, and I need to get back to it, so here goes. This is going to be a five part post on how to Get Data From OneDrive for Business, (using
If you’re new to Power Query, chances are you’re more comfortable doing tricky mathematics using Excel formulas, rather that Power Query formulas. No shame there, but you’ve probably run into a situation where you set up the formulas, refresh your
Hey everyone, A contact at Microsoft is looking for people who DO NOT use Power Query extensively, but DO use “legacy” methods to get external data into Excel. These “legacy” methods include using: Any/all of the commands from Data (Tab)
Hey folks, I'm actually on vacation, so this post is going to be short. I just wanted to make sure you all are aware that there is a new Power Query update available. New features in the July 2016 Power
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
