0

My reports on Power BI service are connected to a data source which is a sql server. I added this to a gateway and scheduled a refresh every morning. I use my microsoft credentials for the connection. Now it's failing after I changed my windows password, any idea how to fix this?

Error message:

enter image description here

Neri Kim
  • 135
  • 1
  • 2
  • 9
  • 2
    In Dataset setting, you can change credentials under `Data source credentials` – Dordi Aug 23 '23 at 11:58
  • It says 'Unable to test connection to data source. Try the credentials again.' There are no options where I can change the credentials. – Neri Kim Aug 23 '23 at 13:23
  • make sure to take control of dataset if it's not already taken – Dordi Aug 23 '23 at 13:32

1 Answers1

1

Go to https://app.powerbi.com/groups/me/gateways and change the settings of the connection and change the Authentication settings:

enter image description here

David Browne - Microsoft
  • 80,331
  • 6
  • 39
  • 67