Problems with Facebook connector (private data)

[mfmom]

Hello everyone and congrats on this excellent forum!

I'm trying to use PowerBI to retrieve data from my personal Facebook page (I have about 300 friends or so) but I'm not able to retrieve any of the "private" insights/* metrics.

For example, the following call just hangs forever "waiting for graph.facebook.com" and nothing happens:

= Facebook.Graph("https://graph.facebook.com/v2.3/Me/insights/page_fans")

And the same happens if I change it to any other private metric:

= Facebook.Graph("https://graph.facebook.com/v2.3/Me/insights/page_fans_by_country")

On the other hand, API calls to retrieve "public metrics" work just fine. For example:

= Facebook.Graph("https://graph.facebook.com/v2.3/Me/feed") or 

= Facebook.Graph("https://graph.facebook.com/v2.3/Me/posts")

I wonder if anyone else has this problem... Is the PowerBI connector broken?

Thanks a lot for your help

[akj2784]

Is there any reason why we are not able to download data from facebook. even I am getting the same. It says waiting for graph.facebook.com and never give any result.

What could be the reason behind this ?

I am following the steps mentioned in the blog.

Regards,

Akash

[v-qiuyu-msft]

Hi @mfmom,

Based on my research, the Facebook Insights represents a single Insights metric that is tied to another particular Graph API object (Page, Post, etc.), see: Insights Metric . In my opinion, you need to use the URL like this to retrieve data: https://graph.facebook.com/v2.3/microsoftbi/Insights.

Besides, when we connect to the Facebook in Power BI Desktop, Facebook connector is relied on the Facebook Graph API. So we can't do much on Power BI side when retrieving data. For this issue, you can contact Facebook Help Centre for help at this link: https://www.facebook.com/help/community?helpref=hc_fnav.

Reference:
Third-party service: Facebook connector for Power BI Desktop

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu