Change Data Source to a different one without modifying the Pivot tables. RRS feed

  • Question

  • Hi Folks,

    I have made a report using a bunch of Pivot tables. I connected to a test ODATA feed URI as source and then pulled all that data and created Pivot tables on top of them. Now I am interested to change the source to a production ODATA feed URI and make all my data refresh it self from that production feed (no change in meta data of feed) without changing my Pivot table queries.

    When I tried to change the datasource to production URI, PowerPivot Window added new tables with names appended by '1' and not refreshed the existing ones.

    Any help would be appreciated.



    Thursday, May 17, 2012 6:07 PM