Forum Discussion
Data from SharePoint (Excel file) not updating in power query
Hi, I connected data from an excel file in SharePoint using the Web ('Get Data'). I do not have any queries or errors. I have read other threads. My refresh button in both desktop and power ...
For the web connector you need to take care of the refreshes yourself, it is not automatic.
Yes, you need to reload your data
If your Power Query produces the exact same result then there willbe no impact to your visuals.
Add a transform step "Use first row as headers"
lbendlin
Super User
Super UserRecommendation is to use the Sharepoint folder connector. Microsoft states that changes are "usually" replicated within one hour.