Get Data From OneDrive for Business
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
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
Yesterday, Microsoft released the June 2016 Power Query update. Even though there are only four items on the list of new features, some of them are quite impactful. What’s new in the June 2016 Power Query Update The four new
One of my favourite tricks to use on a dashboard is to show the Last Refreshed Date. This is important as it lets you know how stale your data is. I think it’s even more important with Power BI, as
I’ve been thinking about this for a while and, after discussing it with a couple of others who are passionate about Power BI… I’m pleased to announce that we have created a new Power BI User Group in Vancouver, BC!
This week’s post was inspired by a question in my Power Query help forum. The poster has a set up data, and needs to keep the most recent entry for each person from a list of data. Background I never
Today’s post isn’t of a technical nature, although it does have a pretty long technical background… I’m now at the point where I need beta testers for a new add-in I’m planning to release. What Does the Add-in Do? In
While I was at the PASS BA conference in San Jose, CA last week, I got an email from a reader asking if Power Query could create a Cartesian Product join. Now I’m an Excel guy, and I’d never heard
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
