Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
np4120
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
v-ljerr-msft
Employee
Employee

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
v-ljerr-msft
Employee
Employee

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.