We found one way to solve it, although it is a pain. In our case, the Dataset was linked/blended/joined to other Datasets within the Data tab (essentially a snowflake diagram with Facts and Dimensions). Once we removed the linking lines, and the Dataset we wanted to replace was its own floating rectangle, the Replace…

Our organization needs this desperately too. I just promoted 8 workbooks up through our 5 database tiers, ending in Prod. Since I cannot repoint Datasets to different (identical in table structure) Connections, I had to MANUALLY recreate Datasets 32 times. It was super error prone, and I think my brain died a little in the…