No oData Connection is updated with Project Online and Excel 2013. RRS feed

  • Question

  • Hi everyone,

    I reproduced the following behavior working with Project Online and Excel 2013.

    As I cannot access directly to the project server database, I use Excel 2013 to connect to a Data Feed.

    1. In the location of the data feed I pasted the URL: https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData

    2. Log on credential: use the sign-in information for the person opening this file

    3. Select tables: I select only one: ConjuntoDeDatosDeFaseTemporalPrevistoDeLaAsignación and clic on Next button.

    4. Clic on Finish

    5. Select Table where I want to view this data

    6. and clic OK

    At this moment, Excel displays a message: (retrieving data...Press ESC to Cancel)

    I can check that Excel processes more than 60,000 records and it continues until it stops or we receive the following message (after more than 90 minutes)

    Microsoft Excel

    We couldn'get data from the Data Model. Here's the error message we got:

    No more information or detail and the OK button is there.

    I suspect it could be a limitation or possible bug.
    Although I tested with another session of Project Online (myself for testing proposals) and it works OK (But, I have not enought information ... only 3 records)

    You consider to contact with MSFT support for this?

    Any response or help will be very apreciated.

    Thanks in advance and have a great day.



    Wednesday, April 3, 2013 3:32 PM


All replies