How to create a facebook ads and google ads connector to powerbi?

[eliasayyy]

hello ive been wondering how can i extract data from facebook ads and google ads without having to export the data from the site everytime and choose dimensions and the metrics everytime, 

there is a conenctor for google ads and ive read a article on making GA4 connector from google big query apis and i loved this integration and was wondering if there is something similar to it for google ads and facebook ads.

ive seen datadoo and windosrar but they are expensive and i need an ongoing flow of data to refresh everyday

[eliasayyy]

Hello @RM7 unfortunately windsorar has clients/ users and connectors limit . I just decided to learn python and created my own and works well. Thank you for the suggestion though.