...
For username, please use:
apikey
For password, copy the API key from dRofus' PowerQuery window as shown below
Info |
---|
If another user want to access the spreadsheet and update data, the user will need to authenticate with their API key as shown in the steps above. |