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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Bakhtawar
Post Patron
Post Patron

Count of No of likes from facebook in power bi

 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

5 REPLIES 5
ChandeepChhabra
Impactful Individual
Impactful Individual

@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
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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?

@v-yulgu-msft  any help please

Bakhtawar
Post Patron
Post Patron

any help please

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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