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

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.

Reply
Chanlyly
New Member

Auto update excel file from Sharepoint list

Hi 

 

Is it possible to auto-update excel file from sharepoint list to dataset?

 

i tried connecting the excel file from sharepoint using paremeter. but now i am stuck on how we made a new file from the folder syncronize to the dataset i created. 

Thanks. 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Chanlyly , not very clear, refer if this can help

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

 

Same config for SharePoint and one drive excel

@amitchandaki already config dataset from my sharepoint and published it. 

the thing is the dataset is not automatically updated when i add more file to the sharepoint. eg. adding next month file.

the dataset only refresh the existing file but not the newly added one. Capture.PNG

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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