Just a thought - are you using excel in the browser?
You can't run OData queries (or almost any powerquery) that way (Oct 2024), you need to be in desktop app.
Edit - here's a working powerquery example you can modify to check that your credentials are valid
If you entered them incorrectly, you can clear them out and reenter:
1 Like