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,

Thanks for your reply, I have already tried this option but i am facing problem in refreshing/scheduling DataSets.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi nabeelshahid,

When refreshing the dataset, the error you get should be caused by the same reason as that you get when connecting to Project Online content pack in Power BI Service. This issue is being investigated, your patience is greatly appreciated.

Thanks,
Lydia Zhang

  • DanielClark's avatar
    DanielClark
    Helper II
    9 years ago

    The OData option via the Desktop App appears to be working for me now with the following appended on the end of the URL.

    /_api/projectdata/[en-us]

     

    Regards,

     

    Daniel

    • 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,