Hello,
I want to Power Query an excel file located on a website protected with a password. more precisely on a document management system (ERoom).
Is it possible to do it with Power Query? My company uses ERoom as a software to share documents between the different departments and the idea was to take informations from some excel files on this platform.
I tried unsuccessfully to take the URL of the excel file and to power query from Web, but I need to specify the login and the password somewhere...
Any clues how to achieve this?
Thanks
Nico
