Facebook Graph Refresh Error

[D_W]

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

[D_W · Accepted 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

[v-juanli-msft]

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

[D_W · Accepted 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

[v-juanli-msft · Accepted solution]

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

[D_W]

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