I have a file that consists of several workbooks and one dashboard, it's all pulling from one data source. Essentially what I want to do is duplicate the same workbooks and dashboard that pulls from a second data source. The data sources will be nearly identical but just one column header will be different.
I tried duplicate one workbook and then replace the data source but that ended up pretty much wiping out all my workbooks and dashboards. Is there a way to pull from a new data source in the same file?
I don`t know what you did when you duplicate a workbook (i guess you mean a worksheet) and replace the data source , but you can check this thread,