Power query unable to connect to network folder but I can access it in file explorer
I have an excel file that uses power query to pull data from multiple csv files stored in a folder on our company network drive. It has been working fine for months. Today I opened the file and refreshed and got an unable to connect error. The folder path is correct. I can navigate to it manually in file explorer and open the csv files without any issue. I checked data source settings in power query and the credentials are set to anonymous because it never needed a login before. I tried remapping the network drive with a different letter and updating the path in power query but still get the same error. Nothing has changed on my end that I know of. Could this be an IT thing where they pushed an update that broke something, I saw some older posts about sensitivity labels causing connection issues. Is that still a thing, I use excel from microsoft 365.
Has anyone else run into this recently and found a fix, I really dont want to rebuild the whole query if I can avoid it. Any help would be appreciated.
[link] [comments]
Want to read more?
Check out the full article on the original site