Power Query API Considerations
This article is the second part in a series on API calls. It will look at some best practices and considerations when using API calls in Power Query.
Articles by Steve Campbell
Handle Errors in Data Refreshes with Power Automate
This article examines using the advanced editor in Power Query to better handle when things go wrong. It will also allow custom actions to be triggered using Power Automate, allowing the rest of the data to be refreshed while alerting the owner by email of data source errors.
Average Household Income Function in Power Query
This post will walk through how to pull an estimated household income from a US address. It will be completed all in the Power Query […]
Historical Stock Price Function in Power Query
This post will walk through how to pull daily stock price from Yahoo! Finance, then transform the data using a technique called a query branch. […]
Custom Sort Order Within a DAX Measure
This post will answer how to sort a measure that returns text values to a custom order, without affecting other columns. It will utilize the […]
Dynamic Visuals using Buttons
Sometimes, we want the users to see different metrics, but do not want to take up too much space on our page. The scenario we […]