Loading...
Quick Links

Looking for a PWA oData Guide

Home Forums Discussion Looking for a PWA oData Guide

Tagged: 

  • This topic is empty.
Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #393511 Reply

    We are spec’ing reports that we plan to create with oDATA. This is our first time using oData.

    Are there any good overviews of creating your oData instance?

    Thanks
    John

    #393535 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    John, I looked at my stuff and found a few broken links. Honestly there is a lot of stuff online. I might start with the Microsoft blog or Brian Smith’s posts. As the old saying goes, everything I learned I was taught online…or something like that…:-)

    #393536 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    I’m assuming you are using Project Online, and if so then odata is already available. There is no turning it on, just accessing it. The url is //servername/pwa/_api/ProjectData. All that is available in the out of box data connections for Excel Services.

    #393537 Reply

    Larry,

    Thanks I will search the blog.

    Don’t I have to define instances of the oData … basically defining what I want to look at? I read somewhere it is best not pull in all data entities …

    Thanks as always,
    John

    #393539 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    There aren’t really instances of OData. OData is slow because it downloads a lot of data and is inefficient. Best practice is to filter the data in your data connection. Filter only active projects, especially if your instance has been around for a while and has a lot of closed projects. Definitely filter tasks and assignments, typically to a specific project. Don’t build reports that rollup tasks for every project. Also, select only the columns you need for that report (very important). There are over 100 default columns in the project OData feed, and all that data will be downloaded unless you select specific columns. Hope that helps…

    #393561 Reply

    This positively helps. I can see the schema but I have not been able to connect yet. It is looking of an account key that I do not know. If you might know where to look please let me know! 🙂

    #393566 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    Sorry John, I don’t know what you are asking about an account key. If this is Project Online then Microsoft O365 support can at least get you started. Otherwise this is a much bigger subject then can be supported entirely via a forum. There are blogs and videos all over that can get you started with creating reports, and many that start from the beginning with connection. Hope that helps…

    #394000 Reply

    Larry,

    I now have oData access in Power BI and in Excel via Power Query. I was just no clicking the right choices …

    thanks
    John

    #394023 Reply
    Larry ChristofaroLarry Christofaro
    Participant

    Glad you got it working, good first step. Now it’s all about the more you know the more you can do.

Viewing 9 posts - 1 through 9 (of 9 total)
Reply To: Looking for a PWA oData Guide
Your information: