Blog
Tips, Tutorials, and StoriesReformatting DAX Queries in Power Pivot with VBA
As a follow up to a previous post on how to call an API and format all of your Power Query code in Excel, here is a walk through on how to do the same thing with DAX queries in Power Pivot. Add a reference to the Microsoft WinHTTP Services Prerequisites: Add a...
Calling USASpending.Gov From #PowerQuery
This week I was asked several times about connecting to the USASpending.gov API. It can be done with a little help with testing from Postman. Once you figure out which endpoint you want to query, you need to figure out: Whether it is a GET or POST request If you need...
