Count of No of likes from facebook in power bi

[Bakhtawar]

 I connect my facebook count in power bi .. now i want number of likes from this page HBLBank e.g. 1.7 M.. i connect Facebook .. type that page name and select likes from connection dropdown.. now i observe that this fetch only 1 record and when i count on ID then this shows incorrect result e.g. this shows 1 .. Kindly check attached power bi file and images

image https://www.dropbox.com/s/850yqjkseo305hx/1.png?dl=0

file https://www.dropbox.com/s/hyacrp1drg24hxk/social%20media.pbix?dl=0

[ChandeepChhabra]

@Bakhtawar 

Please refer this blog post I wrote a while ago - https://www.goodly.co.in/facebook-dashboard-in-excel/

You can see the queries and measures I have used

Thanks

[v-yulgu-msft]

Hi @Bakhtawar ,

Please check if below threads helpful to your scenario.

Facebook Page Likes

Create analysis of a commercial facebook page

Best regards,

Yuliana Gu

[Bakhtawar]

@v-yulgu-msft  i do this in advance editor 

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.8/HBLBank?fields=fan_count"),
    connections = Source[connections],
    posts = connections[posts],
    #"Expanded object_link" = Table.ExpandRecordColumn(posts, "object_link", {"connections"}, {"object_link.connections"}),
    #"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
    #"Aggregated object_link.connections.comments" = Table.AggregateTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {{"id", List.Count, "Count of object_link.connections.comments.id"}}),
    #"Renamed Columns" = Table.RenameColumns(#"Aggregated object_link.connections.comments",{{"Count of object_link.connections.comments.id", "Count of Comments"}}),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Renamed Columns", "created_time", Splitter.SplitTextByDelimiter("T", QuoteStyle.Csv), {"created_time.1", "created_time.2"})
in
    #"Split Column by Delimiter"

now how i call in  in table ? how i get figure?

[Bakhtawar]

@v-yulgu-msft  any help please

[Bakhtawar]

any help please