Power Query

Power Query gem – MissingField parameter

2026-03-07

Sharing a tip about a parameter on certain table and record functions in Power Query to identify how to deal with missing fields.

2022-03-09

A post in the series that covers connecting to Dynamics GP databases in SQL directly in Power Query.

2022-02-25

The third post in the series, discussing data access considerations and options to securely handle your data in a report.

2022-02-08

The first part of my series around Power BI, Excel & Dynamics GP begins with some of the basics, and a way to start learning Power Query.

2022-01-31

Learn about using Power BI to report on Dynamics GP data, starting with some basic approaches to getting started.

2021-11-26

Part 5 of a series where I revisit one of my earlier steps, revise my code from post #2 to use the same approach used in post #4.

2021-11-19

The 4th post in the series around using APIs, specifically around iterating over an unknown number of pages of results, using the ClickUp API.

2021-11-18

The 3rd post in the series, this one about the ClickUp API and how to connect to it with Power Query.

2021-11-12

Part 2 in the series where I’m discussing Power Query with APIs. Today is about paginating over a known number of pages.

2021-11-11

The first post in a short series documenting how to work with some web application APIs in Power Query, using Harvest as my first example.

2020-01-15

A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.