Connecting to Harvest in Power Query

Today’s post is the start of a “mini-series” where I’ll document how I’m working with some different APIs for custom reporting. Today’s post is about Harvest, an app I use for time tracking and billing. This series is aimed at users who may have similar requirements to mine, which was pulling data out of different application APIs for analysis in Power BI and/or Excel. In my limited experience, I’m finding significant differences in how to connect to them or how to paginate through them and I wanted to share my learning on this in case it helps others!

For this post, I will describe the following items:

  • Getting a Harvest’s API v2 Personal Access Token
  • Authenticating with that in Power Query (Power BI or Excel)
  • Using “GET” method on the Time Entries endpoint from the API

Some of the concepts I will cover should be similar regardless of which endpoint(s) you wish to use (at least in the context of the Harvest API). The API documentation is your friend here as it will be the reference to what methods are available, what fields you get back, what data types they contain and what types of query parameters are available.

Continue reading “Connecting to Harvest in Power Query”

Power BI matrix column width sizing

I’ve been working with Power BI a lot lately on a “passion project” for myself. I’ll be starting to share more about that in the coming days but first I wanted to share a little tip (that I wish we didn’t need!) for sizing columns on Matrix visuals in Power BI.

I’ve read a number of other posts and suggestions around creating a measure with all “X’s” but they have never worked for me. I’m probably doing something wrong! 😉

Continue reading “Power BI matrix column width sizing”

Posts navigation

1 2
Scroll to top