cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

DataSource.Error when I try to get Facebook profile picture

This is the response from Facebook Graph Explorer:

 

{
  "data": {
    "height": 200,
    "is_silhouette": false,
    "url": "https://scontent.xx.fbcdn.net/v/t1.0-1/p200x200/picture.png",
    "width": 200
  }
}

 

From the Power BI Desktop I get this error:

 

 

I think it's because the data is inside the "data" object but I don't know how I can fix it.

 

Any ideas?

 

7 REPLIES 7
Highlighted
Super User IV
Super User IV

Re: DataSource.Error when I try to get Facebook profile picture

click edit query, and go to first step which will be source, i guess you see something like record, if yes, click on record, it will show you values from json, and then choose "into table" on convert tab.

 

it will give you name and value columns, select name column and go to transform tab, click "pivot column",  and  in value columns choose you will have "Value" and click advanced option, chooise "Don't aggregate"

 

At end of this , you expect column headers from json with data in rows.

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
New Member

Re: DataSource.Error when I try to get Facebook profile picture

The error is in the source, I can't pass from there.

 

Captura de pantalla 2017-12-12 a las 4.19.47 p.m..png

 

For some reason it expect a "Table" but gets a "Record".

 

Could it be a bug in the Facebook connector?

 

I have no problem with queries that return me JSON like:

 

{
  "name": "Facebook page name",
  "id": "1234456789"
}
Highlighted
Super User IV
Super User IV

Re: DataSource.Error when I try to get Facebook profile picture

try this, go to advance editor and wrap everything in json.document function

 

Json.Document(Facebook.Graph.....)

 

and see if it works.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Super User IV
Super User IV

Re: DataSource.Error when I try to get Facebook profile picture

facebook graph  is part of selection list when you connect to facebook as datasource?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
New Member

Re: DataSource.Error when I try to get Facebook profile picture

I try the Json.Document wrap but it did not work. Smiley Sad

 

Facebook Graph is not part of the selection list.

 

I follow this tutorial but I edit the Source (guiding me from the Graph API Reference) to obtain the data I need. So far almost everything has worked except for this profile image API that returns a different JSON structure.

Highlighted
Super User IV
Super User IV

Re: DataSource.Error when I try to get Facebook profile picture

Gotcha, in that case you need to use Get Data and Web as your data source and I assume that will do it.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
New Member

Re: DataSource.Error when I try to get Facebook profile picture

Yep, I guess I'll do that for now. Thanks.

Helpful resources

Announcements
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!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors