Having to change all data source credentials manua...

renevandeveen · ‎02-10-2021

Hello,

Hopefully you can help me solving the issue i'm facing:

Every now and then, my company wants me to change/reset my Windows password. Whenever i've changed it, I am no longer able to refresh my data in Power BI desktop. My data is stored on OneDrive and uses the same credentials as Windows and Power BI. You would expect a smooth transition there, but it is far from it. Instead, I have to update my credentials for every single report in my data model whereas 90% of them come from the same location on OneDrive.

The strange thing is, is that Power BI recognised that I am signed in. Still though it indicates that the credentials provided are invalid. I'm using the 'Organisational Account' option.

If I then choose 'sign in as different user' I get to see my own credenials 'profile'. Clicking on it applies them and establishes the connection. Which takes ages! It can then take up to 5 - 10 minutes to connect to the data source (the file on OneDrive). I then have to repeat this process very every single data source, whereas they are all in the same OneDrive location.

I've tried signing out in Power BI desktop and signing back in again. This didn't work. Signing out, saving PBI desktop, close it, restart PBI desktop and signing back in, also didn't do the trick.

Please help!

Anonymous · ‎02-18-2021

Hi @renevandeveen ,

Power BI will save the data source credentials. You could edit the credentials in Options and Settings, Date source settings.

Best Regards,

Jay

renevandeveen · ‎02-18-2021

That's exactly what I (have to) do. The problem here is two fold:

1. I would expect these credentials to be updated automatically since it is a single account sign in, but using my Windows credentials

2. The fact that I have to update the credentials individually. For this issue I found a solution: I choose "Global Permissions" instead of "Data Sources in Current File". Here I was able to adjust the credentials for the root folder that contains all the different data files. This way I only have to manually update 1 data source instead of 30, since these data source settings are then also used for the files in this folder.