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.
Greetings,
I have a merge query that does a join to a list with 5 user fields. When I expand those user fields to find the first name and last name the query slows way down. Is this because the user fields are basically lookups? Is this normal?
I tried to optimize the query and reduce the number of fields that I return to the bare minimum. It appears when I hit the Step that extracts the names, the query slows down.
Yes this is normal, merges are fairly expensive and can get (very) slow.
Thanks, but when I take the people fields out of the query, it is under a minute to return.
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.