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