Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
hrics12
Frequent Visitor

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. 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

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

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)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

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)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thank you! This is what I needed. I was just adding other stuff. This was simple and worked great

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors