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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#Power Query
#network folder
#Excel
#CSV files