Retrieve external Data from google facebook youtube

[abhishekg1391]

I have to source data from multiple social platforms for ads costs and returns. I have the following sources I need to connect to:

1. FB ads manager

2. Google DCM

3. Youtube DBM

4. GDN DBM

5. Adwords

I need all your inputs/suggestions on how can i get my data from these sources.

Will get data -> blank query -> advanced editor work, if I write the api url along with fields. I cannot test it yet, so not sure.

Urgent help needed!!!!

Thanks in Advance.

[QueryWhiz]

For that case, I would suggest you to try connecting your data sources with a 3rd party tool, that would save you a lot of time compared to other options. I currently use Windsor.ai make my reports and it has all those connectors, so maybe as a workaround it can be useful since PBI doesn't have native connectors for those sources

[abhishekg1391]

Hi Frank,

Thank you for the reply.

Fb Connector availbale is for Likes/Comments etc. This connector can not be used for Ads data.

For others I don't have good knowledge on M language and will not be able to create connectors for the same.

I was thinking if I can directly use Get Data -> Web and enter a url which can fetch the data. I need help in writing this URL.

[v-frfei-msft]

Hi @abhishekg1391,

1. FB ads manager

There is FB connector for Power BI desktop. you can use it directly.

2. Google DCM

Maybe you can try to use custom connector to have a try.

3. Youtube DBM

Please refer to this blog.

4. GDN DBM

Maybe you can try to use custom connector to have a try.

5. Adwords

Maybe you can try to use custom connector to have a try.

Regards,

Frank