Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Edit credentials for automatic refresh



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!




Super User
Super User

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,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors