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 i am trying to use power bi to try out some facebook analytics, i have imported the page posts that i want but i am unabe to retrieve its comments , so i went to find out its app id, authen token and all the neccessary details to try and to retrieve the comments, the current solution in which i am stuck at; is to use a custom column (newly created column) to retieve the comments using the following code : =Source = Facebook.Graph("https://graph.facebook.com/[id]/comments?access_token=xxx")
the error in which i came across is as follows :
DataSource.Error: Facebook: (#803) Some of the aliases you requested do not exist: [id]
Details:
DataSourceKind=Facebook
DataSourcePath=https://graph.facebook.com/
Detail=https://graph.facebook.com/[id]/comments?access_token=xxx;limit=1000
However, using the facebook graph explorer i have managed to type every single post id and it all shown comments! i am sure all the extracted post id are certainly correct, i have even tried converting the ID field to different data types to try but to no avail, i am not sure why is the algorithum unable to access the comments. Anyone has any ideal why? thanks in advance ! All solutions are welcomed!
@Clement99 wrote:
Hi i am trying to use power bi to try out some facebook analytics, i have imported the page posts that i want but i am unabe to retrieve its comments , so i went to find out its app id, authen token and all the neccessary details to try and to retrieve the comments, the current solution in which i am stuck at; is to use a custom column (newly created column) to retieve the comments using the following code : =Source = Facebook.Graph("https://graph.facebook.com/[id]/comments?access_token=xxx")
the error in which i came across is as follows :
DataSource.Error: Facebook: (#803) Some of the aliases you requested do not exist: [id]
Details:
DataSourceKind=Facebook
DataSourcePath=https://graph.facebook.com/
Detail=https://graph.facebook.com/[id]/comments?access_token=xxx;limit=1000
However, using the facebook graph explorer i have managed to type every single post id and it all shown comments! i am sure all the extracted post id are certainly correct, i have even tried converting the ID field to different data types to try but to no avail, i am not sure why is the algorithum unable to access the comments. Anyone has any ideal why? thanks in advance ! All solutions are welcomed!
I'm not familiar with Facebook APIs, what is the id standing for? UserID or what? What if your post the link returning 803 error in Power BI "https://graph.facebook.com/[id]/comments?access_token=xxx" in a browser like Chrome? I got 803 as well while I tested in Chrome.
By the way, I remembeder that a dataset with such API calling custom column doesn't support schedule refresh. For such API calling scenarios, I'd suggest extact all data in an external script and save the data in some file or database. The connect to the file or database in Power BI.
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 |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |