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"
KT_Bsmart2gethe
Impactful Individual
Impactful IndividualHi Anonymous ,
Which sign-in method did you select?
Please use organizational account.
Regards
KT
Thank you.
I used this method. The problem still persisted. I have reloaded the data using SharePoint folder.
- KT_Bsmart2gethe
check out the link below to see if it helps.
https://data-mozart.com/auto-page-refresh-in-power-bi-everything-you-need-to-know/
Thank you. This link is very helpful.