Skip to content

Gerrish LLC

  • Home
  • Blog

PowerQuery

Using PowerQuery to Make POST API Calls in Excel

July 25, 2024June 3, 2024 by Lianna Gerrish

Yes, Excel Can Make Elaborate API Calls One day I’ll write a blog post that isn’t about PowerQuery, but today is not that day. You may be familiar with PowerQuery in Excel to grab all the files from a folder, or even to make a GET API call, but you can also use it to … Read more

Categories PowerQuery Tags Tips

Easy Dynamic File Sources in PowerQuery

February 27, 2024February 13, 2024 by Lianna Gerrish
dynamic data source in PowerQuery

Changing PowerQuery data sources is a breeze when you link your query to a named range cell in your spreadsheet. No tables, parameters or custom functions required.

Categories PowerQuery Tags Tips

Recent Posts

  • Using PowerQuery to Make POST API Calls in Excel
  • How to Create a Histogram in Power BI
  • Easy Dynamic File Sources in PowerQuery

Search

Top Post Categories

  • Power BI
  • PowerQuery
  • LinkedIn
  • Blog
  • Home
© 2025 Gerrish LLC • Built with GeneratePress