Power Query

Power BI, Excel & GP - SQL sources

The fourth post in the series, showing how to connect to SQL in Power Query (Excel or PowerBI).

Power BI, Excel & GP - Data Access

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

Power BI, Excel & GP - Starting from scratch

The second post of the series discussing some very simple ways to get started with Power BI or Excel and GP data utilizing items a standard user may have access to.

Power BI, Excel & Dynamics GP

The first post in a series, an introduction to what I will discuss around Power BI, Excel, Power Query and Dynamics GP data.

Pagination in Power Query (follow up)

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.

Pagination in Power Query (Part 2)

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

Connecting to ClickUp in Power Query

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

Pagination in Power Query (Part 1)

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

Connecting to Harvest in Power Query

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.

Excel Background Refresh & Pivot Tables

A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.
You've successfully subscribed to JenKuntz.ca
Great! Next, complete checkout to get full access to all premium content.
Welcome back! You've successfully signed in.
Unable to sign you in. Please try again.
Success! Your account is fully activated, you now have access to all content.
Error! Stripe checkout failed.
Success! Your billing info is updated.
Error! Billing info update failed.