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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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