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

how to get facebook business manager data into power bi desktop

kunkumuriarjun — Wed, 24 Aug 2016 18:18:41 GMT

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

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

Eric_Zhang — Fri, 26 Aug 2016 06:20:11 GMT

@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.

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

kunkumuriarjun — Thu, 01 Sep 2016 15:11:30 GMT

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

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

Eric_Zhang — Fri, 02 Sep 2016 07:09:11 GMT

@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?

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

kunkumuriarjun — Fri, 02 Sep 2016 07:32:47 GMT

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

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

kunkumuriarjun — Fri, 02 Sep 2016 07:34:23 GMT

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

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

MarianneElver — Fri, 24 Feb 2017 07:40:48 GMT

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

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

Anonymous — Fri, 07 Apr 2017 15:59:58 GMT

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&time_increment=1&fields=clicks,impressions,reach,spend

- 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.

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

Tanim — Wed, 12 Apr 2017 14:19:26 GMT

Thank you so much, this was simple and easy!

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

megearin — Thu, 15 Jun 2017 23:43:56 GMT

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

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

mede — Wed, 05 Jul 2017 08:44:11 GMT

Could you provide details on how did you generate the access token for reading ad insights?

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

mede — Wed, 05 Jul 2017 08:47:58 GMT

Could you provide details on how you generated the access token for reading ads insights?

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

marianamarques — Mon, 24 Jul 2017 14:16:35 GMT

Hi @Anonymous, I'm trying to connect using your steps and it's not really working, do you know if they have changed anything since you posted it? Thanks

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

Anonymous — Mon, 24 Jul 2017 18:23:06 GMT

Hi @marianamarques,

The method still works. You may need to change the API version. My last post was using 2.8, but they're now on 2.10. So that version number would need to be used in the URL.

Here's another resource to help generate a new temporary access_token: https://developers.facebook.com/tools/explorer/145634995501895/

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

ApurvaKhatri — Tue, 17 Oct 2017 21:30:34 GMT

Hello , I have tried these steps and I get my ad id and access code also. However, I am facing the following issue on clicking on the link

{
   "error": {
      "message": "(#274) The ad account is not enabled for usage in Ads API. Please add it in developers.facebook.com/apps -> select your app -> settings -> advanced -> advertising accounts -> Ads API. Account 1486621934964404 not enabled for this application.",
      "type": "OAuthException",
      "code": 274,
      "fbtrace_id": "B+OcLTSGwqS"
   }
}

How Do I resolve this?

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

Anonymous — Tue, 17 Oct 2017 21:45:06 GMT

Hi @ApurvaKhatri,

This is question for Facebook, but I migh be able to help.

1. Go to: https://developers.facebook.com/?ref=pf

2. Click the dropdown on the right hand side for "My Apps"

3. Select your Facebook account name (will be at the top of the dropdown list)

4. In the next page, click "Settings" on the left

5. Click "Advanced" under Settings

6. Scroll down and under "Advertising Accounts" you'll see the account id's listed that are authorized

7. If the account id you want for reporting isn't listed, click "Ads API" on the right and check off the account id you want the API to have access to

8. Once the account id is listed under "Advertising Accounts", click "Save Changes"

9. Generate a new auth token by clicking "Marketing API" on the left and click "Tools". In the next window check the boxes for "read_insights" and "ads_read" then click "Get Token". Copy the token and use that in the URL for the Power BI Facebook connection

Hopefully that'll give you what you need.

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

ApurvaKhatri — Tue, 17 Oct 2017 21:49:24 GMT

There is no app in my organization facebook developer

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

Anonymous — Tue, 17 Oct 2017 21:51:00 GMT

Ah, you'll have to create one. Here's some info on that: https://developers.facebook.com/docs/apps/register/

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

ApurvaKhatri — Tue, 17 Oct 2017 21:51:50 GMT

Thank you.. I will try and get back.

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

MarianneElver — Thu, 19 Oct 2017 09:14:21 GMT

Now that a huge number of IDs are involved in Facebook advertising, could you please be a little more specific on what is/where to find the "Facebook Ad ID" in step 3? Thanks!