Forum Discussion
Trying to get Power BI to work with an Excel Data Source
Microsoft Support helped me find the answer. It's actually pretty easy. Just need to go to Edit Queries > Data Source Settings and you can get to all the remembered credentials.
Why though would this be hidden under the Edit Queries button is beyond me. It really needs to be displayed somewhere a little more obvious. Or maybe shown as an option under Get Data as well...
But in here I can edit the settings and clear ones that I don't want applied.
Microsoft Support helped me find the answer. It's actually pretty easy. Just need to go to Edit Queries > Data Source Settings and you can get to all the remembered credentials.
Why though would this be hidden under the Edit Queries button is beyond me. It really needs to be displayed somewhere a little more obvious. Or maybe shown as an option under Get Data as well...
But in here I can edit the settings and clear ones that I don't want applied.
Helper IIITHANK YOU for this. It must have saved some old 365 passwords to the sharepoint directory in question. The error message was worthless, a generic access denied warnging and no more. I was stumped for days.