Forum Discussion
Merge Updating with Refresh
Hello - I have two tables (Downtime and OR) and they are merged together with a key identifier. I just refreshed both tables, but my merge didn't update with the most recent data. I have the ...
Hi nataliesmiy1357 ,
Based on your description, you can check the following areas to see if they are the cause of the unsuccessful refresh.
First, revisit the merge operation in the Power Query Editor to ensure that the key identifier for the merge is set correctly and that there is no mismatch in data types between the key columns in the Downtime and OR tables. Data type mismatches can sometimes cause unexpected problems with merge operations. Second, make sure that merged queries are not inadvertently excluded from report refreshes.
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly