If you've tried to use Power Query to get data from a password protected Access database, you'll know that it doesn't go well. Using the standard From Microsoft Access Database connector allows you to browse for the database and select
It honestly pains me to have to write an article on how to hide the Copilot chiclet, but I find this thing far too intrusive. If you have a Copilot license assigned to your user account in M365, you may
I've been using Microsoft Office for a long time - long before there were web versions of Excel, Word and Power Point. And while Microsoft has done a great job of building the web based versions of these applications, there
Now I know that not everyone is going to want to do this, but one of the things that I find which really helps me understand complex calculations or visuals, is to manually replicate the values used. It helps me
Introduction I’m a big fan of building Box and Whisker plots (also known as Box plots to those in the statistics world) to interpret certain data sets. While I tend to use these for charting Power Query refresh times, they
Introduction I’m a big fan of Excel's Box and Whisker chart (also known as Box plots to those in the statistics world). While they can be used in a variety of applications, my personal use case is to try and
The question of how to convert Julian dates to Gregorian dates using Power Query came up today in a course I was teaching. Although I haven't ever used JD Edwards myself, apparently this is quite common in that system, so
After writing up my article on connecting to Spotify using Power Query, I thought it would be helpful to provide some functions that will allow you to get album and track data from Spotify. A sample project to illustrate getting
Spotify has a massive music database, and in this article we're going to look at how to connect to Spotify using Power Query. Step 1: Get API credentials from Spotify The first thing you'll need to do is to collect
Recently, a reader commented on a blog post that I wrote back in 2015. Their question essentially boiled down to working out how to label duplicates with Power Query. As an additional twist though, they also wanted to ensure that
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
