2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Maiden230
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article