Your Voice Matters – Power Query Quality
Some time ago we embarked on a bit of a crusade to get Microsoft to fix a specific issue with Power Query related to performance. I posted about it in detail on the Power Pivot Pro blog, and have been
Some time ago we embarked on a bit of a crusade to get Microsoft to fix a specific issue with Power Query related to performance. I posted about it in detail on the Power Pivot Pro blog, and have been
My recent post on showing the Top X with Ties inspired a discussion on ranking methods. Where I was looking to rank using what I now know as a standard competition rank, Daniil chose to use a dense ranking method
A couple of years ago, the Power Query team added Parameters as a proper object, but I kept on Creating Dynamic Parameters in Excel Power Query the same way as I always had. The reason for this is two-fold: the
This post is a guest article from Marcus Croucher, a finance professional based in Auckland, New Zealand. Marcus instantly fell in love with Power Query after seeing how it can easily transform data in ways Excel finds difficult, and how
ON-DEMAND: Power Query Academy Course Description What is Power Query? Power Query is the most important data analysis tool since PivotTables. It allows you to clean, reshape, and combine your data with ease, no matter where it comes from. Introducing
Legacy Installers for Power Query and Power BI Desktop Let's be honest, one of the incredibly cool things about Power Query and Power BI Desktop is that they are updated monthly. We always get new features and bug fixes, but
Data Connectors for Power Query in Excel One of the things that makes Power Query so powerful is able to connect to almost any type of data source. So how come you find yourself asking, "Why is this connector not
This week's blog post on solving business problems with Power Query is a guest post by Alex Jankowski Does your business or work group have manual tasks that are repeated regularly, such as data re-entry, copy/paste functions, sending the same old email,
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
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.