Excel Power Query Anonymous Credentials RRS feed

  • Question

  • Hi all I have an excel file with a power query linking to a share point. When I set up the query I used the New Query option and have no issues. When I share this with my colleagues who have the same access as me the get a pop up box “Acess Web Content” with Anonymous selected. If they then select windows and select use my current credentials and hit connect it works.

    is there anyway in can default to windows and not anonymous is that something I would set in the power query I am total lost with this and would appreciate some help.

    Friday, June 12, 2020 12:36 PM


  • Hi Emkay79. There's currently no way to change the default credential dialog selections. It sounds like you'll need to tell the users which credential type to select (which could be done via instructions embedded in the Excel file itself).


    Monday, June 15, 2020 11:31 PM