Facebook Insights dahsboard

[singarfield]

Hi! I have a commercial Facebook page I run, and I currently have to export the excel reports manually and import them into power bi. Do you know if there is any way of skipping this process and connecting the two directly? The types of insights I look at are: page impressions, video views, page reach 28 days, post reach 28 days, post comments, page likes, etc. So it's the information that you can only get from Facebook insights on your own page. I know Tableau offers a connector, so I was hoping something similar could be achieved with Power Bi. Thank you, singarfield

[EugeneLebedev]

You can either write your own connector to extract data from Facebook or you can get this code off the shelf. Here is a ready-made solution for connecting Power BI to Facebook Ads: https://vidi-corp.com/facebook-account-ads-connector-to-power-bi-looker/

[LivioLanzo]

Hi Singarfield there is also a connector in Power BI, under 'Online Services' in the Get Data dialog box

[singarfield]

Hi @LivioLanzo, from what I have seen that doesn't provide the sort of insights I need, it provides things like comments, news, and other public data. No performance data. Is this not the case? Thank you Singarfield

[v-yuta-msft]

@singarfield,

About how to connect to facebook in power bi desktop, please follow instructions in this documentation:

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-facebook-analytics.

Regards,

Jimmy Tao

[singarfield]

Hi @v-yuta-msft, I have already tried this, but it only shows me information from the owner page (my personal page) not from the commercial page I run. I need insights from the commercial page. I also get an error when I try to view comments. Thank you Singarfield

[v-yuta-msft]

@singarfield,

I would suggest you to submit your idea here.

Regards,

Jimmy Tao

[singarfield]

Hi @v-yuta-msft, Do you mean then that there is no possible way currently of doing what I need? I was hoping there was a way of using the Facebook Graph API Explorer. Thank you, Sara

[v-yuta-msft · Accepted solution]

@singarfield,

Unfortunately, power bi has not developed such kind of connector, if you really want to connect to Facebook Graph, you may try odata.feed instead.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.