cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kunkumuriarjun Regular Visitor
Regular Visitor

how to get facebook business manager data into power bi desktop

Hi 

I have an account in facebook business manager, there we have list of webistes data (related facebook).

URL: https://business.facebook.com/

When I am using Power BI Desktop to get the data by using 'Facebook' option it is taking me to personal Id facebook.

But its not taking me to facebook business manager.

Please guide me how to get the facebook business manager data into power bi.

 

Thanks,

Nagarjun K

 

64 REPLIES 64
Moderator Eric_Zhang
Moderator

Re: how to get facebook business manager data into power bi desktop

@kunkumuriarjun

 

Based on my research, the "online services->Facebook" in Power BI desktop can not get data from facebook business manager. However Fackbook has provided the Business Manager API and I think your can call the specific APIs in Power Query, check a similar demo Get Data from Twitter API with Power Query.

 

The most effort that you will spend is on FaceBook Business Manager API side, you may have to research and dig into it. Meanwhile you can submit your request on Power BI Ideas and vote it up.

kunkumuriarjun Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Thanks.......... I am able to get the data but in facebook business manager they are total number of likes and they are showing data in day wise chart.

But when I am trying get the facebook data, it just showing total number of likes. 

How to get the data in daywise (detail data).

 

Thanks,

Nagarjun K

Moderator Eric_Zhang
Moderator

Re: how to get facebook business manager data into power bi desktop

@kunkumuriarjun

 


@kunkumuriarjun wrote:

Thanks.......... I am able to get the data but in facebook business manager they are total number of likes and they are showing data in day wise chart.

But when I am trying get the facebook data, it just showing total number of likes. 

How to get the data in daywise (detail data).

 

Thanks,

Nagarjun K


 

I think there'll be some effort that you have to put on researching the Facebook APIs, if they support a way to get data in daywise rather than total.

 

By the way, could your share how you get data from the facebook bussiness manager?

kunkumuriarjun Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

We have an 'facebook' data source option in Power BI tool. By selecting that I got facebook data.

kunkumuriarjun Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Or can choose by using API : https://developers.facebook.com/tools/explorer/

MarianneElver Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

Hi, Are you using a special connector to get that data from the business manager? I still only see the one that retrieves info from the page. If possible, could you share any info/screendumps on your proces? Thanks in advance! Marianne
echofoxtrot Regular Visitor
Regular Visitor

Re: how to get facebook business manager data into power bi desktop

I know I'm a little late to the party on this, but I've come across a pretty straightforward way to get Facebook Ad marketing data in Power BI. Using this resource: https://developers.facebook.com/docs/marketing-api/insights/v2.8 I created a URL that will get the data. Here are the steps I went through:

 

1. Get Data

2. Web

3. URL = https://graph.facebook.com/v2.8/youradid/insights?access_token=youraccesstoken&date_preset=lifetime&...

     - Change "youradid" to the Facebook Ad ID

     - Change "youraccesstoken" to the Facebook access_token for your account (I watched this video to get that info: https://www.facebook.com/marketingdevelopers/videos/924152364365830/)

4. Use "Anonymous" connection and "Connect"

5. Click on the highlighted "list" next to "data" in the query

6. Click "To Table" then "Ok"

7. Expand columns

8. Format it and setup the reports

 

That did it for me, and it refreshes Online with an Anonymous connection.

 

FYI: Reference the Facebook Insights API link above for any other fields you want to add, but what I'm using gave me everything I need.

 

I just set this up last night, so I haven't done thorough testing, but so far so good.

 

Hope this works for you guys and helps you out.

Tanim Frequent Visitor
Frequent Visitor

Re: how to get facebook business manager data into power bi desktop

Thank you so much, this was simple and easy! Smiley Very Happy

megearin Visitor
Visitor

Re: how to get facebook business manager data into power bi desktop

Hi There - is this all pending you have a facebook graph API app built in a particular setting? 

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)