Forum Discussion
Solved
How to Connect to Latest Excel File in SharePoint Without Slow Refresh?
Hello, I have a SharePoint folder where an Excel file is added each month for the previous month. For example: August CSAT scores summary.xlsx September CSAT scores summary.xlsx October CSAT sco...
rkhidesh , This same logic should apply for sharepoint folder
https://wkrzywiec.medium.com/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711
amitchandak
Super User
Super Userrkhidesh , This same logic should apply for sharepoint folder
https://wkrzywiec.medium.com/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711
Hello, creating a shortcut of the SharePoint folder to my Desktop solved the slow refresh time issue. Thank you!