Forum Discussion
Solved
Dynamic dates to pull GeoTab data into powerBI.
I'm trying to pull a table called "Trips" from GeoTab in an API call. When I set the search in the "params" equal to a date in the past it will pull the live data from that date to the current date. ...
Hi hrics12
What you can do in power query is to use a function that will always go back to the past 32 days. Here is an example below. Put this code below where you are passing the parameter
Date.AddDays(DateTime.LocalNow(),-32)Thank you! This is what I needed. I was just adding other stuff. This was simple and worked great
