Forum Discussion
Facebook Query run in Graph Explorer returns no data in PowerBI
I got past the limit of 100 issue and now want more columns then the default view returned so I tested the syntax in the Facebook API explorer which returns data but when i add the query to the Facebook connector no data is returned. See below.
This one works fine:
Facebook.Graph("https://graph.facebook.com/v2.8/howardums2/posts?limit=100")
This one works and returns data in the API Explorer but not when added in the desktop Facebook connector query.
Facebook.Graph("https://graph.facebook.com/v2.8/howardums2/?fields=posts.limit(100){name,from,shares,status_type,to,application,story}")
See anything wrong. Also, can we assume if a query works in the Facebook API explorer it should work with the Facebook connector assuming no syntax errors
NormanP
Hi np4120,
I just verified that the following query works all fine for me with the latest version(2.47.4766.801 64-bit (June 2017)) of Power BI Desktop on my environment. :smileyhappy:
let Source = Facebook.Graph("https://graph.facebook.com/v2.8/howardums2/?fields=posts.limit(100){name,from,shares,status_type,to,application,story}"), posts = Source[posts] in postsRegards
1 Reply
Hi np4120,
I just verified that the following query works all fine for me with the latest version(2.47.4766.801 64-bit (June 2017)) of Power BI Desktop on my environment. :smileyhappy:
let Source = Facebook.Graph("https://graph.facebook.com/v2.8/howardums2/?fields=posts.limit(100){name,from,shares,status_type,to,application,story}"), posts = Source[posts] in postsRegards