Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |