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.
I have a query (Query A) and I appended a query (Query B) to the end of it. In another query (Query C) I am doing a merge to Query A based on a unique identifier in Query A. However, when I do the merge it does not pick up any of the data I appended to Query A from Query B. Any way to get the data from Query B to be pulled by the merge statement from Query C to Query A? Example steps below.
Note, that I know I could just do a second merge from Query C to Query B and do some additional calculated steps to get to the same spot but I would prefer not to go that route as the data is quite large and adds additional time to the refresh time.
Example layout:
Query A (Database Query):
Project Code | Project Manager
Query B (Manual Excel Spreadsheet):
Project Code | Project Manager
Append Query B to Query A
Query C (Master Table):
Project Code | Merge to Query A to get Project Manager
Solved! Go to Solution.
It looks like Query B (Project Code) isn't matching.
You can examine the data with the newish 'column distribution' , 'column profile' etc features and see what's up with the data( there might be spaces or hidden characters in the field used to merge) so it'll need to be cleaned up.
OR the merge is done with an inner join and there are no matches
It looks like Query B (Project Code) isn't matching.
You can examine the data with the newish 'column distribution' , 'column profile' etc features and see what's up with the data( there might be spaces or hidden characters in the field used to merge) so it'll need to be cleaned up.
OR the merge is done with an inner join and there are no matches
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.