Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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. I need to be dynamic so it will always pull the data from 32 days ago. Everything i've tried just gives me blank data in the report. It also loads data from 2015. Does anyone know what to put and where to put some code in the advanced editor so it will always call for data from 32 days ago? Anything will be helpful
Solved! Go to Solution.
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)
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.