Forum Discussion
Data Source Credentials Password Change
I have a semantic model on the power bi service that has three data source connections. I've entered my credentials for all three via OAuth and have successfully connected. This is all done through a Personal Cloud Connection.
Now say in 3 months when my company requires me to update my password what happens to this semantic model? Is model not going to refresh because I changed my password or will it work fine since I authenticated via OAuth and didn't hard code my password?
In my experience, you will need to re-authenticate the credentials used in the shared cloud connection.
9 Replies
If you or anyone else coming on this thread still have this problem, heres what I did that might help you.
Use case : I do not have a service principal set up yet
Workspace identity is not compatible with my sharepoint data source as it did not work.
What I did:
To move on with getting my data pipeline to run successfully with all the data flow acivities and the likes,
- I went to the settings from the fabric global level
- clicked managed connections and gateways
- on the next page, select the 3 dots by each connection > settings > edit credentials
- sign in again
- repeat for each connection
- refresh to make sure they say 'online'
- resave a pipeline if you have pipelines by adding an activity (wait for ex) save, remove wait activity, save again to refresh the credentials.
- run the pipeline(s) after wards
This worked for me without having to click through every source query in each data flow and i will be working on getting my IT admin to set up a service principal. Pain in the neck but i got my work flows working again.
Hope this helps someone
Hi MyNameHere2213,
Thanks for reaching out to the Microsoft fabric community forum.
When your company enforces a password change, any existing OAuth tokens linked to your old credentials will become invalid. This means the Power BI Service won’t be able to refresh your semantic model using those connections until you reauthenticate as suggested by others. Once your password changes, please go to the dataset’s settings in the Power BI Service, open the “Data source credentials” section for each of your three connections, and sign in again with your updated credentials. Doing this will restore the connection and allow scheduled or manual refreshes to work as expected.
I would also take a moment to thank FBergamaschi, Tutu_in_YYC and blopez11, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.Hello Hammad,
Since I have many data sets (50+) and is any there method that allow me to reauthenticate for all the data sets at the same time when my windows password is changed, instead of doing it one by one? Thank you.
Regards,
Watson LIAO
Hi MyNameHere2213,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround so that other users can benefit as well. And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi MyNameHere2213,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.Best Regards,
Hammad.
- FBergamaschi
Super User
You will have to reauthenticate once passwords change or the refresh will fail
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
- Tutu_in_YYC
Based on my experience, the refresh will fail. As it will not be able to request access token using the old password.
blopez11In my experience, you will need to re-authenticate the credentials used in the shared cloud connection.
