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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Auto refresh dataset from excel stored in OneDrive business and sharepoint list

Hi,

I can't find any solution to automatically update my dataset made of data from an excel document stored on a OneDrive and data from a sharepoint list.

Since both are online data, it might probably exist a solution but I can't find out. 

 

When I modify my excel for example, nothing happens on my dataset and report. I have to use power BI desktop, manually update and then upluad to apply changes, but I want to make this step automatic.

I also tried using flow, but it doesn't work.

I also have an error message about missing credentials when I try to update my dataset from app.powerbi.com, but when I go to my dataset setting the credential option (under gateway) is grey and not clickable.

 

Any idea ?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Nevermind, I deleted everything and made it again from scratch, it now works.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Nevermind, I deleted everything and made it again from scratch, it now works.

Hello @Anonymous 

 

If it doesn't work for the next time, you can have a look at the below Microsoft documents.

 

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-desktop-file-onedrive

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-csv-file-onedrive

 

Regards,

 

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.