Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Make a report months ago tracking Facebook page analysis with Reactions from posts.
It uses a function to call the reactions per post id that adds another column for the reactions to each post :
(postid as text)=>
let
Source = Facebook.Graph("https://graph.facebook.com/v2.8/" & postid & "/reactions?access_token=EAAGEP68ILu8BAHrIZBG408AkdnDJuXXOeC8Lsz2inWmnCJKH2TZBR7sHiPakeOdkLIz1USqocZAQVfavAJtT5pnO6KfetWdQ2BSsupVdXeIQ2w5PhSOiOprNNQQIW6L2u6KuOvD5MAB0xeKFDhGPamxQChLGi7dHDfx0yr3ZAXn9ZBr6XSKSIvyfrahEbshkZD")
in
Source
I can see the latest data in the query editor but the data won't refresh to the report.
However it will not refresh and comes up with the following error :
If any one has any advice or an alternative way to reporting Facebook page stats on Reactions , i also am beginning to get problems with the sentiment analysis on this report but i'm pretty sure this is from the connection to the Azure cognitive services.
thanks in advance
D
Solved! Go to Solution.
Just seen the app side in backend of Facebook this may be failing due to requirements to have the app registered and live.
Will look into this, looks like a lot of extra setup needed
Hi @D_W
Does my reply help you?
if your problem have solved, could you accept it as a solution to let more people know the solution to this issue?
If not, please don't hesitate to ask me.
Best Regards
maggie
Hi @D_W
It seems the access token has expired.
The issue is more related to Facebook graph API, you can consider to generate a never expire access token for FaceBook.
https://sujipthapa.co/blog/generating-never-expiring-facebook-page-access-token
Additionally, you could consider alternative ways
How to integrate Power BI to the Facebook Graph API
Tutorial: Facebook analytics using Power BI Desktop
Bests Regards
maggie
Just seen the app side in backend of Facebook this may be failing due to requirements to have the app registered and live.
Will look into this, looks like a lot of extra setup needed
Hi @D_W
Does my reply help you?
if your problem have solved, could you accept it as a solution to let more people know the solution to this issue?
If not, please don't hesitate to ask me.
Best Regards
maggie
Thanks for the reply, yea i originally made the access token non expiring when this was setup back in february.
Unless this process is now redundant and i should do it again?
Checked the other two methods they are good for high level posts but i mainly was reporting on Reactions to posts and sentiment analysis on comments
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |