Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi community,
Has anyone faced same problem like me. We have requirement to change windows password every 3 months and doing that it always fails the dataflow refresh and I go manually to each dataflow which is like 50 dataflows and update the credential.
My dataflows gets SQL data via on-premise datagateway.
There is no way I can update the data credential as the button seems to have disabled .
I know I am doing it wrong way , any idea how can this be simplified?
Thanks in advance as always
Solved! Go to Solution.
@schoden is it really the credentials on the dataflow or the credentials on the gateway which are failing? My understanding is that when a gateway is being used, the data source credentials used in refresh are those which are entered in on the gateway.
If it's actually the data source credentials on the gateway which are expiring, the gateway administrator would need to update those. For that reason I believe it's typically recommended that "service account" credentials (which don't expire) be used on the gateway, as opposed to personal credentials.
See below source:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#add-a-data-sourc...
@schoden is it really the credentials on the dataflow or the credentials on the gateway which are failing? My understanding is that when a gateway is being used, the data source credentials used in refresh are those which are entered in on the gateway.
If it's actually the data source credentials on the gateway which are expiring, the gateway administrator would need to update those. For that reason I believe it's typically recommended that "service account" credentials (which don't expire) be used on the gateway, as opposed to personal credentials.
See below source:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#add-a-data-sourc...
@ebeery You are right ...it has to be credential at the gateway ..otherwise will have to edit credential in every dataflows.
Thanks for the info 😄 wil have a play around
I logged out from everything (windows too) to fix it.
urgh, I had this. It was a log out and log in to my laptop again fix.
Hi @samdthompson Can you please tell me more/......Log out from browser ? Power BI Service online?
I cleared all cached password from my browser. Still didnt change.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |