Forum Discussion

nabeelshahid's avatar
nabeelshahid
Frequent Visitor
9 years ago
Solved

Microsoft Project Online

hi, I am trying to connect to 'Microsoft Project Online' Service via Power BI Web and after authentication i get below error  
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi nabeelshahid DanielClark,

    The issue is resolved, please check that if you have any problems connecting to Project Online content pack.

    Thanks,
    Lydia Zhang

nabeelshahid's avatar
nabeelshahid
Frequent Visitor
9 years ago

hi,

Well when you are asked to add the URL, application automatically appends '/_api/projectdata/[en-us]' to it.

My source URL this already added to it.

 

DanielClark's avatar
DanielClark
Helper II
9 years ago

Via the Get Data option in PowerBI.com Correct?

 

I still have the same issue as you via this method, but this workaround is possible in the Desktop version of PowerBI.

 

  1. Open PowerBI Desktop
  2. Get Data > OData Feed
  3. Enter https://<TenantName>.sharepoint.com/sites/<PWA Name>/_api/projectdata/[en-us]
  4. Use OAuth2 to connect with your PowerBI account (Now Organisational Account)

Though not a solution for the problem posted, it is a workaround that allows you to access and work with the data. It is possible to publish to the PowerBI Service online as well, though the data source will not refresh and must be done via the desktop app.

 

 

Hope this is useful, I am lookin forward to the App on the service working again also.

 

Regards,

  • dzehner2's avatar
    dzehner2
    Frequent Visitor
    9 years ago

    This workaround got me past the error message, but now it's stuck in the Navigator trying to connect to Project Online. Any ideas?

  • dzehner2's avatar
    dzehner2
    Frequent Visitor
    9 years ago

    Got this to work by dropping the [en-us] off the end of the URL. Thanks for this workaround!

    • dzehner2's avatar
      dzehner2
      Frequent Visitor
      9 years ago

      I guess I spoke too soon... I got the list of Tables to show up, but when I try to download data I get a 404 error. Anyone have a solution to this??

      • DanielClark's avatar
        DanielClark
        Helper II
        9 years ago

        Checked it again from desktop myside: (Updated my original answer as well)

        1. Open PowerBI Desktop
        2. Get Data > OData Feed
        3. Enter https://<TenantName>.sharepoint.com/sites/<PWA Name>/_api/projectdata/[en-us]
        4. Use Organisational Account to connect with your PowerBI account 

         

        Step 3: /_api/projectdata/[en-us] without this I got the 404 error. (ensure this is the right language for your Project Web App?)

        Step 4: The authetication method that works now appears to be called Organisational Account.

         

        Otherwise, can you post a screenshot of dump of the error you see.

         

        Regards,