Facebook Business Manager Data

[Lsvzz]

Hi!

I am fairly new to Power Bi and I am trying to figure a way to bring all the data, from all the accounts/Campaings/Agencies from my business manager to power bi, I tried using the connector on Pbi but it links it to my actual username of the account, not the accounts that I manage for other people. 

Is there an easy way to bring all the data to Pbi? Like 1 query to bring all the campaings and accounts like we have with the other facebook connector?

Any help would be appreciated! and thanks in advance.

[EugeneLebedev]

Here is a ready-made code solution that does exactly that: https://vidi-corp.com/facebook-ads-connector-to-power-bi-looker/

[Anonymous · Accepted solution]

Hi @Lsvzz,

I don't think default facebook connector suitable for your requirement.

In my opinion, I'd like to suggest you use other connector with facebook api.

Facebook develop documentation

Loading paged and related data from MS Graph API into Power BI using a recursive Power Query functio...

Iterate Over Dynamic Web API Pages With Power Query – How To Resolve Cursor-Based Pagination

Regards,

Xiaoxin Sheng