Forum Discussion
Data from SharePoint (Excel file) not updating in power query
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"
Thank you.
I had difficulties using the SharePoint connector so I used The Web connector. A few questions-
Does this mean the data will not update with the Web connection?
Will I have to reload my data using the SharePoint?
Will this interfere with my current visuals?
Super UserFor 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.
Thank you.
I have reloaded the data using 'SharePoint Folder' as I will need the data to refresh automatically.
I am not facing the issue of the coloumns not displaying names as it did when I loaded it via the 'Web' function.
Please see comparinson below. I would like my coloumns to display the header names instead of Coloumn 1,2,3 etc.
Loaded the data via 'SharePoint folder'
Loaded the data via 'Web'
- lbendlin
Add a transform step "Use first row as headers"
Thank you very much.
This worked.