Tips, Tutorials, and Stories

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