PowerBI & Project Online performance issues RRS feed

  • Question

  • We have presently 35 GB data stored on Project Online over Microsoft Cloud.

    We have written a bunch of reports using Excel PowerBI OData connection to the PWA instance hosted by MS.

    Since couple of months, the reports end working, and stop over Error 500 and Insufficient Memory messages.

    Microsoft tells us to install SSIS, a kind of mirroring approach, requiring an SQL server to be installed and operated on premises, which is what we wanted to avoid. (whence the cloud appraoch we opted for).

    Did anyone of you face this performance problem and how did you solve it?

    Friday, January 5, 2018 6:43 PM


  • Would you be able to provide us with the following information:

    • The version of Excel you are using
    • The exact error message(s) you are seeing
    • If you are seeing an Unexpected Error dialog, can you click on "Copy Details" and include that


    Thursday, January 11, 2018 3:18 AM