locked
Changing data feed URL RRS feed

  • Question

  • Hi,

     

    The website we are developing comes with an OData data feed which will be consumed by Excel PowerPivot. I'd like to create a relatively complex workbook for the API and offer that as a boilerplate project to my customers.

     

    While I am working on the workbook it should connect to our development web server. Before giving the workbook to our customers, I need to change the URL for the data feed so that it points to our production web server. Is there any way to change the URL? I only know how to create new tables based on different feeds, but that way my excel spreadsheets still point to my development server tables.

     

    Thanks,

     

    Adrian

    Wednesday, October 13, 2010 12:15 PM

Answers

  • Adrian, you can change the URL as follows:

    - On the Design ribbon tab, choose Existing Connections

    - Select the data source connection and click Edit

    - Change the URL and click OK

    • Marked as answer by Adrian Grigore Tuesday, October 19, 2010 1:56 PM
    Thursday, October 14, 2010 7:44 PM

All replies

  • Adrian, you can change the URL as follows:

    - On the Design ribbon tab, choose Existing Connections

    - Select the data source connection and click Edit

    - Change the URL and click OK

    • Marked as answer by Adrian Grigore Tuesday, October 19, 2010 1:56 PM
    Thursday, October 14, 2010 7:44 PM
  • Thanks a lot, John!
    Adrian Grigore http://www.logmytime.de
    Tuesday, October 19, 2010 1:57 PM