Tagged: oData setup
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?
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…:-)
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.
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,
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…
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! 🙂
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…
I now have oData access in Power BI and in Excel via Power Query. I was just no clicking the right choices …
Glad you got it working, good first step. Now it’s all about the more you know the more you can do.