Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm currently working on a facebook dashboard. I'm pulling the following data using the page_id, and my questions regarding them:
2. Shares, comments and likes from the page, but also peoples' data when their profile are public
"DataSource.Error: Facebook: (#100) Cannot request permissions of other users
Details:
DataSourceKind=Facebook
DataSourcePath=https://graph.facebook.com/
Detail=https://graph.facebook.com/v2.6/XXXXXXXXXXXX/permissions?limit=1000"
When i enter it in the browser, it looks like I need an access token (from google graph API ?). But I wouldn't know where to fit that token, there is no such parameter anywhere in my code.
3. Any other useful data I'm missing and that I can get legally on fb ?
Thanks for your help !
Antoine
Here's the mother query I use to pull data for 2.:
let
page_id = "XXXXXXXXXXXXXX",
get_from_facebook = get_from_facebook(page_id),
SampleOrNot = if SampleOrNot = false then get_from_facebook else Table.FirstN(get_from_facebook, SampleOrNot as number),
#"Expanded object_link" = Table.ExpandRecordColumn(SampleOrNot, "object_link", {"created_time", "message", "connections"}, {"post.timestamp", "post.message", "post.connections"}),
#"Added Index" = Table.AddIndexColumn(#"Expanded object_link", "post.id", 1, 1),
#"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"story", type text}, {"post.message", type text}, {"post.timestamp", type datetime}}),
#"Inserted Date" = Table.AddColumn(#"Changed Type", "post.date", each DateTime.Date([post.timestamp]), type date),
#"Inserted Time" = Table.AddColumn(#"Inserted Date", "post.time", each DateTime.Time([post.timestamp]), type time),
#"Removed Other Columns" = Table.SelectColumns(#"Inserted Time",{"story", "post.id", "post.timestamp", "post.date", "post.time", "post.message", "post.connections"})
in
#"Removed Other Columns"
Where SampleOrNot is a parameter = 3 and get_from_facebook is:
// to be added: type parameter, date parameter
let
from_facebook = (page_id as text) => Facebook.Graph("https://graph.facebook.com/v2.6/"
& page_id
& "/feed?limit=100")
in
from_facebook
Hi @AntoineCh,
As the Facebook connector in Power BI Desktop relies on the Facebook Graph API, and it seems that most of your questions are related to the Facebook Graph API itself, I would suggest that you also post the questions on the Facebook forums for better assistance.
Regards
Hi @v-ljerr-msft,
Not really, no. My questions are mostly on what you can do through the connector, and whether or not it's enough to do what I want to do. I've read some documentation on the api, but I'm wondering if I can reproduce the output through the connector.
Antoine
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |