They are all Odata feed queries, which I figured out yesterday is not an internal data connection. so I figured out how to setup that gateway for nothing. It is funny you ask about projects, because it is my Projects query that wont load. Assignments, resource and task are loaded and I can refresh them in Power by on a schedule now. Thanks for help yesterday! What is the issue with project data you uncovered? Does it have anything to do with authentication type, I feel like my issue may revolve around that but always open to other ideas.
We are using a mix of everything which I assume is part of our issues but everyone is on Office 365. Most all resources are accessing their task list and completing their task via project on line with a Project lite license. Program managers as myself are using project pro on our local machines tied to the PWA thru a sharepoint connection. Basically I will start a new project in the web app, it creates an associated sharepoint site, but I do 90 % of project management thru project pro on my desktop.
When I go to project center in PWA and the go to reports tab and open the report in question once it loads I have to edit it in excel to refresh the connections. When I pull it into excel and try to follow the steps you laid out above I get as far as Data/ and then everything is greyed out like the workbook is protected. IT guys says no. I have even tried to save to my machine and I hit the same wall. Any ideas?
Also I have been volentold to get a working set of reports complete this month. I have the basic structure in place and I can pull a lot of the data but really have no idea how to get to the point of making counts by person, late delievery by person etc… If you have any advice or ideas of a good resource to walk me thru creating these reports it would be a huge help.
Thanks for the ideas. I think you may be on to something with the non-rebuilt cube. we are pulling the reports from Odata that is external from everything else, meaning I have to pull the report down to excel and refresh then upload back to PWA. Now that I think about it we have even seen where a task in updated in a personal task list but is not seen in the PWA schd. until the schd has been opened up in edit mode and republished. If that is the case then I am sure the refreshing of Odata external just compounds the issue. If I could figure out how to get my reports tied to auto refreshing Odata I would be doing myself a huge favor. again Any Ideas there?
