Edit credentials for automatic refresh

[Jorgen_VDB]

Dear, 

I am working on an automated dashboard for tracking the progress on the program implementation of a UNESCO program related to the sustainable development goals. Based on a form being filled in, an excel should be updated with power automate. From this excel my dataset is created and dashboards depend on this dataset. I want to refresh my dataset using an action in power automate but get an error. Also when i want to us a scheduled refresh for my dataset in power BI I am told to edit the credentials. The first error for adding a row to my excel from the form is a badgateway for which I am posting questions on another forum. However I would like some help with editing the credentials for the connection of my dataset to the MS Teams/Sharepoint Excel. I have no idea how to do this. Can anyone help me out please what do i fill in below and what does it depend on? Thank You!

[ibarrau]

Hi. You almost have it. Change the authentication method for OAuth2 and login with you Microsoft Work or Professional account. Once it's logged in you can start refreshing, scheduling, etc.

If the problem persists, there can be an issue in how you are connecting the sharepoint excel

I hope that helps,