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

My Excel dashboard broke. Have a power query that pulls from a folder.... but getting "Unable to connect". I can browse and open in Explorer. Any ideas?

As a test: I simply started a blank Excel file > Get Data > From Folder - and pointed to the folder of xls files. Immediately met with the error.

The full error message: Unable to connect We encountered an error while trying to connect. Details: "We can't load data from this source due to its type of protection, or you may not have permission to extract data."

I have a Excel dashboard that has a couple power queries that aggregate xls files in a given folder. (ie: I will drop in a xls exported from another program, and the "dashboard" aggregates and graphs over time)

This month, I am getting problems. I deleted the file I just added - and it didn't change anything. It seems I'm getting some kind of permission issues, but I don't know why. I can browse/read/write the folder just fine.

Any idea where I need to resolve? Files are located on a network drive, but I have full read/write access in Explorer.

submitted by /u/jdsmn21
[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
#real-time data collaboration
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#financial modeling with spreadsheets
#real-time collaboration
#Excel
#dashboard
#power query
#data
My Excel dashboard broke. Have a power query that pulls from a folder.... but getting "Unable to connect". I can browse and open in Explorer. Any ideas?