Power BI, Excel & GP – SQL sources
A post in the series that covers connecting to SQL directly in Power Query.
Microsoft Excel Power BI & Fabric Power Query
Microsoft Excel Power BI & Fabric Power Query
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.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & GP – Starting from scratch
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, starting from scratch.
Microsoft Excel Power BI & Fabric Power Query
Power BI, Excel & Dynamics GP
Details about a planned series of posts on Power BI with 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 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 Query
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.
Power Query
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.
Microsoft Excel Microsoft Office Power Query
Excel Background Refresh & Pivot Tables
A post about Excel and the Enable Background Refresh setting as it relates to Pivot Tables.