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.

Maximum columns in a SmartList

A #TipTuesday post showing what message a user gets if they have more than 190 columns on a SmartList in Dynamics GP.

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.

2021 year in review

My year in review post for 2021.

Top 10 Blog Posts from 2021

My top blog posts from 2021 and how they compared to 2019’s top 10 (since I missed doing this for 2020).

ROE issue in Canadian Payroll

An ROE issue where Box 15B does not generate the correct value on the printed report in Canadian Payroll in Dynamics GP.

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.

Clear Recent Items list in Power BI Desktop

How to clear the recently opened items list in Power BI Desktop.

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.
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.