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.
Got 2 tables: Accounts (290+ rows) and Events (7800+ rows),
I merge those tables by this query:
let
Source = Table.NestedJoin(Accounts,{"Account"},Events,{"account"}, "T", JoinKind.LeftOuter),
#"Expanded public durable_events_counter" = Table.ExpandTableColumn(Source, "T", {"action", "count"}, {"action", "count"})
in
#"Expanded public durable_events_counter"
Then I put Account and action fields of the joint table onto the report table. No filters applied.
What is strange: I don't see some rows of the joint table in the report view, while they can be seen in the query editor.
How that is hapenning? How can be fixed?
I use 2.60.5169.4101 64-bit (July 2018) version of Power BI desktop.
Hi @Anonymous,
What kind of rows were missing? Did they have any commonality? When you only put Account and action fields onto the report table, was each row unique? Duplicates would not be shown in visual. Besides, if not joined two tables, were those rows visible on report?
Regards,
Yuliana Gu
What kind of rows were missing? The text of Actions of certain Accounts.
Did they have any commonality? Yes, they were Actions of certain Accounts.
When you only put Account and action fields onto the report table, was each row unique? Yes. Each combination of Account/Action is unique.
Besides, if not joined two tables, were those rows visible on report? Yes, Actions for certain Accounts where visible in the Events table and in the visual-table based on Events table.
Hi @Anonymous,
I noticed that you joined two tables with LeftOuter Join, which would leads some blank values of account in the right table. Please enable the "Show items with no data" in table visual to see if it works.
Regards,
Yuliana Gu
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 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |