Forum Discussion
Facebook page insights with Power BI
Hi dmitryo,
Add a new blank query in Power BI Desktop, then paste following code in Advanced Editor and you will be able to get insights data from the your Facebook page.
let
Source = Facebook.Graph("https://graph.facebook.com/v2.5/pagename/insights")
in
Source
There is an example for your reference.
Regards,
Lydia
Hello Anonymous!
Thank you for your answer.
Why this won't work for versions greater than 2.6? We have 2.9 current, if I'm not mistaken.
How can I get other metrics? I need page likes, page impressions (payd, organic, viral, total), reach and so on.
How to execute query similar to:
"https://graph.facebook.com/v2.9/PAGE_NAME/insights?metric=page_impressions&since=2016-01-01
Cheers,
Dmitry
- Anonymous9 years agoNot applicable
dmitryo,
The issue is related to Facebook API, you can test v2.5 and v2.9 in Facebook console. By using v2.9, facebook api returns error message, thus Power BI Desktop can't get any data from Facebook. Please contact Facebook support to troubleshoot this issue.
Regards,
Lydia Zhang