Forum Discussion
Solved
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...
In my experience, you will need to re-authenticate the credentials used in the shared cloud connection.
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