Forum Discussion

jbotero's avatar
jbotero
Frequent Visitor
8 years ago
Solved

Facebook comments: loading taking forever

Hello everyone.   In PBI Desktop I have been trying, with no luck, to load Facebook comments and likes. I am able to load the data to Query Editor and to transform it in several ways, but when appl...
Need Help
Show and Tell
v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi jbotero,

 

Per my understanding about your issue. It might be related to the Expanded object_link. 

 

Once you load your data from Facebook graph api, the records in object_link are nested. Maybe the number of these records are huge and based on my research it seems like there exists Facebook graph api rate limiting. Please refer:

 

https://www.quora.com/Whats-the-Facebook-Open-Graph-API-rate-limit

https://developers.facebook.com/docs/marketing-api/api-rate-limiting

 

So I would suggest you to try some small number of records. See if the issue persists.

 

Thanks,
Xi Jin.