Forum Discussion
Facebook Business Manager Data
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.
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
Iterate Over Dynamic Web API Pages With Power Query – How To Resolve Cursor-Based Pagination
Regards,
Xiaoxin Sheng
2 Replies
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
Iterate Over Dynamic Web API Pages With Power Query – How To Resolve Cursor-Based Pagination
Regards,
Xiaoxin Sheng
Here is a ready-made code solution that does exactly that: https://vidi-corp.com/facebook-ads-connector-to-power-bi-looker/
