Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jbotero
Frequent Visitor

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 applying the changes, PBI takes forever to load. I have left PBI loading for hours and it keeps "applying query changes".

 

I have taken the query to show you what I have done:

 

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.8/hamburguesaselcorral/posts"),
    #"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
    #"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
    #"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"message"}, {"object_link.connections.comments.message"}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Expanded object_link.connections.comments", "created_time", "created_time - Copy"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column", "created_time - Copy", Splitter.SplitTextByDelimiter("T", QuoteStyle.Csv), {"created_time - Copy.1", "created_time - Copy.2"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"created_time - Copy.1", type date}, {"created_time - Copy.2", type time}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [#"created_time - Copy.1"] > #date(2018, 4, 1))
in
    #"Filtered Rows"

I appreciate all your help and hope that the info I have given to you is enough to solve my problem.

 

Thanks!

 

Juan

1 ACCEPTED SOLUTION
v-xjiin-msft
Solution Sage
Solution Sage

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.

View solution in original post

1 REPLY 1
v-xjiin-msft
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.