Home

Getting Project Server data through Power Query Odata Feed from outside network

%3CLINGO-SUB%20id%3D%22lingo-sub-870507%22%20slang%3D%22en-US%22%3EGetting%20Project%20Server%20data%20through%20Power%20Query%20Odata%20Feed%20from%20outside%20network%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-870507%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Project%20Server%20administrator%20permissions%20for%20a%20company's%20Project%20Server%20(on-premise)%20instance.%26nbsp%3B%20Access%20to%20the%20project%20data%20via%20Power%20Query%20OData%20Data%20Feed%20works%20for%20other%20administrators%20when%20connected%20directly%20to%20the%20network.%26nbsp%3B%20I%20am%20an%20external%20user%20and%20don%20not%20connect%20directly%20to%20the%20network.%26nbsp%3B%20I%20can%20successfully%20log%20in%20to%20Project%20Server%20remotely.%26nbsp%3B%20I%20can%20also%20see%20the%20XML%20data%20when%20entering%20the%20Odata%20URL%20in%20a%20browser%2C%20however%2C%20when%20I%20try%20to%20authenticate%20using%20Power%20Query%20to%20the%20Odata%20Feed%2C%20I%20get%20the%20following%20error%20using%20Windows%20Authentication%3A%20%22Odata%3A%20the%20given%20URL%20neither%20points%20to%20an%20Odata%20service%20or%20a%20feed%3A%20'https%3A%2F%2F%26lt%3B%3CEM%3EURL%3C%2FEM%3E%26gt%3B%22%3C%2FP%3E%3CP%3EIf%20using%20Organizational%20Account%20authentication%2C%20I%20get%20the%20following%20error%3A%20%22The%20underlying%20connection%20was%20closed%3A%20An%20unexpected%20error%20occurred%20on%20a%20receive.%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-870507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-887592%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Project%20Server%20data%20through%20Power%20Query%20Odata%20Feed%20from%20outside%20network%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-887592%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20a%20sort%20of%20similar%20problem%2C%20maybe%2C%20attempting%20to%20use%20an%20*atomsvc%20feed%20from%20an%20SQL%20Reporting%20Server%2C%20which%20used%20to%20work%20great%20for%20years%20and%20does%20work%20for%20others%20in%20my%20company.%26nbsp%3B%20May%20I%20ask%20what%20version%20of%20Excel%20you%20are%20using%20versus%20your%20collogues%3F%26nbsp%3B%20I%20have%20been%20dealing%20my%20issue%20for%20weeks%20and%20have%20confirmed%20it%20used%20to%20work%20in%201803%20(and%20still%20does%20if%20I%20roll%20back)%20but%20is%20now%20broken%20in%201902.%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F226770%22%20target%3D%22_blank%22%3E%40David%20Howe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
David Howe
New Contributor

I have Project Server administrator permissions for a company's Project Server (on-premise) instance.  Access to the project data via Power Query OData Data Feed works for other administrators when connected directly to the network.  I am an external user and don not connect directly to the network.  I can successfully log in to Project Server remotely.  I can also see the XML data when entering the Odata URL in a browser, however, when I try to authenticate using Power Query to the Odata Feed, I get the following error using Windows Authentication: "Odata: the given URL neither points to an Odata service or a feed: 'https://<URL>"

If using Organizational Account authentication, I get the following error: "The underlying connection was closed: An unexpected error occurred on a receive."

1 Reply

I am having a sort of similar problem, maybe, attempting to use an *atomsvc feed from an SQL Reporting Server, which used to work great for years and does work for others in my company.  May I ask what version of Excel you are using versus your collogues?  I have been dealing my issue for weeks and have confirmed it used to work in 1803 (and still does if I roll back) but is now broken in 1902.  @David Howe 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies