cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: Facebook Query run in Graph Explorer returns no data in PowerBI

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. Smiley Happy

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

r0.PNGr1.PNG

 

Regards

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Facebook Query run in Graph Explorer returns no data in PowerBI

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. Smiley Happy

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

r0.PNGr1.PNG

 

Regards

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors