Skip to content

Gerrish LLC

  • Home
  • Blog

Lianna Gerrish

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

How to Create a Histogram in Power BI

May 23, 2024February 20, 2024 by Lianna Gerrish
Example of histogram in Power BI

Creating a histogram in Power BI is easy when you use the Groups function. Read on to learn how.

Categories Power BI 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