Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |