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
JonAcampora
Regular Visitor

Facebook Posts Table Column Limited on API v2.8

The Facebook Posts table is now limited to 5 columns on the latest version of Power BI Desktop (April 2017 Update). It is now referencing v2.8 of the Facebook Graph API.  It was previously referencing v2.2 and bringing in 28 columns of data.  Here are some screenshots to help explain.

 

The facebook graph URL with v2.2 was used in prior versions of Power BI Desktop, and returned 28 columns of data.

Facebook Graph v2-2 Posts Table.png

 

The facebook graph URL with v2.8 was used in prior versions of Power BI Desktop, and returned 5 columns of data.Facebook Graph v2-8 Posts Table.png

 

The documentation for v2.8 of the API still includes these additional columns.  I'm specifically looking for the Type column.  Here is the link to the documentation.

 

https://developers.facebook.com/docs/graph-api/reference/v2.8/post

 

Is this a change with Power BI or with the Facebook Graph?  If it is Power BI, is there any way to fix it?  Thank you! 🙂

 

Jon Acampora
Excel Campus
excelcampus.com
1 ACCEPTED SOLUTION
Suvidha
Employee
Employee

Hi Jon,

 

That is right, we updated our Facebook API's to v2.8. 

As per the facebook documentation, since v2.4, "Nodes in the Graph API will return fewer fields by default. Use the 'fields' param to explicitly ask for the set of fields you want. If you ask for an explicit set of fields, the response will not contain any extra fields that you did not ask for".

As of now, we don't pull in any additional fields. So, if you want "type", "name" fields, you could do something like

= Facebook.Graph("https://graph.facebook.com/v2.8/me/posts?fields=type,name")

 

Thanks,

Suvidha

View solution in original post

2 REPLIES 2
Suvidha
Employee
Employee

Hi Jon,

 

That is right, we updated our Facebook API's to v2.8. 

As per the facebook documentation, since v2.4, "Nodes in the Graph API will return fewer fields by default. Use the 'fields' param to explicitly ask for the set of fields you want. If you ask for an explicit set of fields, the response will not contain any extra fields that you did not ask for".

As of now, we don't pull in any additional fields. So, if you want "type", "name" fields, you could do something like

= Facebook.Graph("https://graph.facebook.com/v2.8/me/posts?fields=type,name")

 

Thanks,

Suvidha

Hi Suvidha,

Thank you for the quick reply.  This makes sense.  Just out of curiousity, are there any plans to expose that list of parameters in a listbox, so the user could choose which fields to add to the query?  I'm guessing it takes a lot of work to keep up with the Graph API, but this would be nice to have in Power BI.  

 

Thanks again! 🙂

 

 

Jon Acampora
Excel Campus
excelcampus.com

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.