Forum Discussion
windsor.ai API / date question
this has nothing to do with the connector, it's limited from bing ads, they don't allow pulling data older than 2 years,
The solution here would be to use a data warehouse to get your historical data and then connect it to power bi.
details from bing here
https://docs.microsoft.com/en-us/advertising/guides/release-notes?view=bingads-13
- Pikachu-Power3 years agoImpactful Individual
Adel but when I say "&date_from=2020-01-01" i get data older than two years. but it is not dynamic. you mean something like TODAY - 3 YEARS is not allowed from the bing ads webside?
- Adel3 years agoHelper III
exactly yes, but i know that with windsor.ai you can pull historical data older than 2 years with almost all marketing platform you would need a data warehouse, and windsor.ai has it's own cloud so maybe that could help.
- Pikachu-Power3 years agoImpactful Individual
Okay thats strange... windsor accepts
&date_from=2020-01-01
We acually just have to set the date dynamic.
artemus you didnt use "&date_from=". maybe there is the mistake?
Adel thanks for yout alternative idea