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.