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
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
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
Hi @Bakhtawar ,
Please check if below threads helpful to your scenario.
Create analysis of a commercial facebook page
Best regards,
Yuliana Gu
@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?
any help please
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |