Change tables for visualizations quickly

[Anonymous]

I have a dashboard with two tables. The tables are exactly the same except for that the data source for one is a static file saved on my desktop and the data source for the other is the same file on OneDrive.

I built the first two pages based on the desktop file, before deciding to move the file to OneDrive and getting the data feed from there. 

Now I want to link the first two pages to the 2nd table(OneDrive) without having to change the columns individually. Is there a quick way of doing this?

[edhans]

No, because the visual is pointing to specific fields. If has measures, you can redo those measures to point to the OneDrive file. This is one reason explicit measures are better than implicit measures - you can programatically direct what they pull from.

You could also copy the OneDrive tables/visual to the other page then change the columns in them.