Need to check what connection is being used for reports. PS2013 RRS feed

  • Question

  • Hi,

      We have the vendor who has implemented couple of reports. But now some reports are not refreshing data real time. Wanted to backtrack and figure out what connection is being used. Can someone advise.

      In the PWA i click on project reports > Excel reports (shows set of reports). I want to figure out how connection is being set or what is it using a system account or sql account to connect.



    Monday, May 15, 2017 6:32 AM


  • Hi,

    First step would be to click on "data" tab in Excel, "Connections", select a connection and click on "properties". Then you should see the connection string and the account used.

    Hope this helps,

    Guillaume Rouyre, MBA, MVP, P-Seller

    • Marked as answer by Mac_cs Tuesday, May 16, 2017 11:48 AM
    Monday, May 15, 2017 2:15 PM