Facebook Query run in Graph Explorer returns no data in PowerBI

[np4120]

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,...}")

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

[v-ljerr-msft · Accepted solution]

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. 

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
    posts

Regards