Changing connection string in datasource for power pivot for excel 2013 Dynamically RRS feed

  • Question

  • Hi,

    I am using powr pivot for execel 2013 to create dash board reports and tabular reports.

    My reports (power pivot reports for excel 2013)   are using my one of my server connection for data source.

    Whenever run other server i need to change connection details dynamically.

    I tried in different way using vb script also but no use. No not posted about this issue even in microsoft forms also.

    My Scenario:

    i have Server A and Server B

    My reports are created using Server A, i wan to change into server B dynamically i mean whenever run the powerpivot reports on server B that time i need change connectio string with out manually (No needto got existing connection string mannualy)

    Friday, September 27, 2013 4:35 PM