i use windsor.ai to import Bing Ads into Power BI. I have a question concerning the date_present field in the URL:
https://connectors.windsor.ai/bing?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
I would like to load all dates from 01.01.2020 until today in a dynamic way.
date_preset=last_2years is possible but there is no date_preset=last_3years. I could say &date_from=2020-01-01 but that is not dynamic. After 10 years i would import all dates from 10 years.
How could I solve that problem in the URL? Is it maybe possible to say TODAY - last_3years for the date_present field?