locked
Getting an error connecting PowerBI to Project Online API RRS feed

  • Question

  • On Project Center, I see my url is of this format:

    https://mycompany.sharepoint.com/teams/pw3x5/Projects.aspx

    The url I try to use in PowerBi is

    https://mycompany.sharepoint.com/teams/pw3x5/-url/projectdata/[en-us], and I use OAuth2 for authentication.

    I get a status code 400 - Failed to update data source credentials

    This seems to be following what the directions indicate.

    Help?

    Tuesday, June 27, 2017 9:03 PM

All replies

  • Hi Tim,

    https://mycompany.sharepoint.com/teams/pw3x5/_api/ProjectData


    Ben Howard [MVP] | web | blog | book

    Tuesday, June 27, 2017 10:32 PM
  • Hello,

    The correct URL would be <PWASiteURL>/_api/ProjectData/[en-US]

    Is this in the Power BI Desktop tool or in the Power BI App? What steps are you taking?

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Wednesday, June 28, 2017 7:35 PM
  • I tried that url, and no success. I have tried access both from the PowerBI link in MS Project Online, and from PowerBi desktop.
    Thursday, June 29, 2017 5:47 PM