Looking for a PWA oData Guide

Home Forums Discussion Forum Looking for a PWA oData Guide

Tagged: 

Viewing 8 reply threads
  • Author
    Posts
    • #393511
      John Murphy
      Member

      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
      Larry 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
      Larry 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
      John Murphy
      Member

      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
      Larry 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
      John Murphy
      Member

      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
      Larry 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
      John Murphy
      Member

      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
      Larry 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 8 reply threads
  • You must be logged in to reply to this topic.