Forum Discussion
Very odd merge behavior in power Query
I did check for duplicates and the extra spaces. If it had no columns that would make sense. As i said doing a complete refresh seemed ot clear its head and it was fine. Thanks for response.
Hi mike_asplin ,
If one column is expanding correctly while other columns are not populating as expected, it could be due to duplicates in the Enquiry Status Reason Funnel table. Check for any rows with the same key "Sales Enquiry" that have null values in other columns. In Power Query's preview mode, it will restrict the view to the first 1,000 rows, so make sure to check the source data.
Additionally, verify if there are any trailing spaces in the key values in both tables. Ideally, the key should be "Sales Enquiry," but it’s worth checking for variations like "Sales Enquiry ".
You mentioned that Power BI is referencing the old table. Please review your Power Query, as it might be related to earlier references you made. If you could share the complete Power Query, we would be able to diagnose the issue more effectively.
Thanks .
If this response was helpful in any way, I’d gladly accept a kudo.
Please mark it as the correct solution. It helps other community members find their way faster
I did check for duplicates and the extra spaces. If it had no columns that would make sense. As i said doing a complete refresh seemed ot clear its head and it was fine. Thanks for response.
mike_asplin , whats the fix to this issue ?
close the pbix, reboot reopen and fixed it