cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
np4120 Frequent Visitor
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
v-ljerr-msft Super Contributor
Super Contributor

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

1 REPLY 1
v-ljerr-msft Super Contributor
Super Contributor

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 182 members 2,200 guests
Please welcome our newest community members: