•2 min read•from 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
Our take
It sounds like you're encountering a frustrating issue with Power Query unable to connect to your network folder, despite being able to access it via File Explorer. Given that your setup has functioned smoothly for months, this sudden error could be related to recent changes in your IT environment, such as updates or sensitivity labels. While you’ve already attempted to remap the drive and check data source settings, exploring these potential IT-related modifications may provide clarity.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Have you encountered some users who can't refresh Power Query?I’m running into a Power Query refresh issue in Excel that I haven’t been able to resolve through Googling. We have an Excel file with Power Query connections that a team uses to refresh and pull updated data. The file is stored in a shared Google Drive folder, and both teams involved have the same access permissions. Here’s the issue: One team is able to refresh the queries without any problems. Another team receives errors when trying to refresh, with error messages that the source file cannot be found or that columns are missing. Additional context: We are all using Microsoft 365. Permissions appear to be identical across both teams. I am able to refresh the file successfully without errors, so are other people within my team, so obviously not a source file issue. I’ve created other Power Query–based Excel files in the same shared folder, and the affected team can refresh those without any issues. The problem seems isolated to this specific file. Has anyone encountered this issue before? Has anyone resolved this issue before? My last ditch effort would be to just recreate the whole thing and see if that fixes it. Here's the error message if you're interested. It doesn't help: https://i.imgur.com/Gss7SHt.png submitted by /u/TheRiteGuy [link] [comments]
- PowerQuery hangs forever in refresh when multiple computers are used to editI'm having a sudden problem in which when I make edits on another computer and try to refresh PowerQuery on my primary computer, it refreshes forever or sometimes refreshes for hours before throwing up a random memory error. Normally, the refreshes take between 3 and 10 minutes. I've used this setup for a year now with no issues before last week. I have an relatively elaborate PowerQuery setup that pulls in shared data from many sources, including online, Dropbox, SharePoint, OneDrive, and in-workbook excel tables. Lots of merges, lots of custom formulas. All file locations are variable parameters that are changed via a dropdown in Excel. I do most of my work on an up-to-date Windows 11 version of Excel running on a Mac via Parallels. The other machine I occasionally edit on is another up-to-date version of Excel on Windows 11. They are synced via Dropbox. At first I thought my VM was corrupted, so I reinstalled fresh. It worked fine until the next time I edited on another machine. I've deleted all PowerQuery and Excel caches and it still happens. Nothing I'm doing is new, so I'm not sure why it suddenly breaks. Any thoughts? submitted by /u/WorldsGreatestWorst [link] [comments]
- Refreshing Power Query saved in OneDriveHello. So my files are saved in a onedrive folder, personal, i want to refresh my power queries or tables without having to close the source file. Error prompts when i to refresh data and i have to close the source file first. Thank you submitted by /u/Physical_Bell2760 [link] [comments]
- Power Query with a Power BI dataset loses access rights (ResourceAccessForbiddenExcpection)We have some Excels in our organisation that work with Power Query on Power BI semantic models. We use AnalysisServices.Database to connect to our model with a custom query. That has been working perfectly fine for a long time, but since last week (I think) it stopped working and every couple of hours we need to login again (even though the login screen is stilll filled in with the proper account). This looks like some kind of token that expires. Anyone know what is going on here and how to fix this? submitted by /u/JosVermeulen [link] [comments]
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