none
Power Query custom Windows credentials authentication with Odata feeds RRS feed

  • Question

  • I am currently trying to find a way for a customer to connect with Power Query to access their published Odata-feed (which is hosted by Microsoft NAV 2013 R2).

    For security reasons the NAV server is set to only accept Windows as an credential type. This means that the current user credentials on the client is passed on to the webservice.

    The problem: The users of the system is often off site and working on another domain with a VPN connection to the NAV-environment. With that said Power Query does not pass the "correct" AD-information when accessing the published Odata-feed which means that the user is not authorized.

    The users have no problem typing in the webservice adress in a web browser and type in the Windows credentials when prompted and access the feed. But in Power Query there is no option for typing in custom Windows Credentials when refreshing the data. I am looking for a way to change which AD-credentials that are sent thru Power Query and then to the Odata webservice.

    I've tried with WebAPIKey and Basic authentication. But since the NAV-server/Webservice is set to only accept Windows authentication I'm in the dark..

    Thanks in advance!

    Wednesday, December 10, 2014 8:11 AM

Answers

  • I'm afraid this isn't something we currently support, though we have considered implementing it. We do loosely track feature requests and use them to prioritize future work.
    • Proposed as answer by Curt Hagenlocher Wednesday, December 10, 2014 12:34 PM
    • Marked as answer by Adam Abenius Wednesday, December 10, 2014 12:51 PM
    Wednesday, December 10, 2014 12:34 PM

All replies

  • I'm afraid this isn't something we currently support, though we have considered implementing it. We do loosely track feature requests and use them to prioritize future work.
    • Proposed as answer by Curt Hagenlocher Wednesday, December 10, 2014 12:34 PM
    • Marked as answer by Adam Abenius Wednesday, December 10, 2014 12:51 PM
    Wednesday, December 10, 2014 12:34 PM
  • We too would be very interested in this feature as the tool is very powerful, but useless to us without this option.  




    • Edited by ebol2000 Wednesday, February 11, 2015 11:10 PM
    Wednesday, February 11, 2015 11:09 PM
  • I'm also hugely interested in this feature. Started using Power Query solely for this purpose.
    Monday, February 23, 2015 1:35 PM
  • Is there a uservoice site for PowerQuery where we could vote for this suggestion?
    Monday, May 4, 2015 11:35 AM
  • Yes, but there's no need. As of today's release (https://support.office.com/en-us/article/Whats-new-in-Power-Query-936b2fca-4168-41ad-bbbd-7b83856b6776?ui=en-US&rs=en-US&ad=US) this feature should work in Power Query.
    Monday, May 4, 2015 9:05 PM