Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm having some trouble setting up some Facebook integration to a Power BI report.
I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.
I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.
is there a way to edit the code below so it only counts if the name is not null?
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})
aybe something like:
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})
Thanks!
Solved! Go to Solution.
@epod184 wrote:
Hi,
I'm having some trouble setting up some Facebook integration to a Power BI report.
I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.
I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.
is there a way to edit the code below so it only counts if the name is not null?
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})aybe something like:
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})Thanks!
Instead of the AggregateTableColumn, you could try to add an custom column as
=Table.RowCount(Table.SelectRows([likes], each [name] <> null))
@epod184 wrote:
Hi,
I'm having some trouble setting up some Facebook integration to a Power BI report.
I've followed the extensive Power BI guide, but it appears the Facebook API has changed since then, and it doesn't work the same way.
I am trying to count the amount of "likes" each post recieves, but the Power Query aggregate count function is counting nulls.
is there a way to edit the code below so it only counts if the name is not null?
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count, "Count of name"}})aybe something like:
= Table.AggregateTableColumn(#"Expanded connections", "likes", {{"name", List.Count("name"<>null), "Count of name"}})Thanks!
Instead of the AggregateTableColumn, you could try to add an custom column as
=Table.RowCount(Table.SelectRows([likes], each [name] <> null))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |