SmartList & SmartList Builder

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 & Fabric Microsoft Excel Power Query

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

2021 year in review

My year in review post for 2021.
Miscellaneous

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).
Canadian Payroll

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

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.
Power BI & Fabric

Clear Recent Items list in Power BI Desktop

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

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

Connecting to ClickUp in Power Query

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

Power BI number formatting tips

Two tips for formatting numbers in Power BI, replacing zeroes with dashes and displaying something other than blanks.
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.
Press ESC to close.