Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

jusTodd

Get Data from Folder and am unable to browse folders

Submitted by Advocate IV on ‎02-16-2023 11:08 AM

This needs a serious and permanent fix and NOT some random workaround or registry edit.

 

This is NOT a good User Experience, which slowly seeping into other software.  I just noticed PowerAutomate has the same problem.

 

When attempting to browse to a folder, myself and many millions of others are apparently unable to do so without copy/pasting a folder location or disabling Desktop backup through OneDrive.

 

Yes all things are update to the latest version.  This stopped working with the December update to Power BI and is now one of the most annoying "features" of the program.

 

This is core functionality, Microsoft!  Why you break it?

 

Anyone reading this ... please do not respond that ridiculous workaround being discussed or some registry fix.  One should not have to disable core functionality to enable other core functionality.

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎02-16-2023 05:12 PM

Hi @jusTodd 

What do you mean by unable to browse folders you mentioned? Can you explain it in detail ? If you get data from folder in Desktop , then you cannot open the folder in local ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

jusTodd
Advocate IV
Advocate IV
‎02-17-2023 06:53 AM

@Anonymous , what I mean is that when attemtpting to "Get Data" from a Folder, the only thing I (and apparently thousands of others) are able to see is Desktop.

 

jusTodd_0-1676643869395.png

 

I can cancel, go back and paste a file path and it will go to that file path.

 

jusTodd_1-1676644366099.png

The only solutions I have found are to disable OneDrive Desktop synching, which disturbs my own personal workflow, or edit the registry, which is not always effective and seems require further edits.

 

I also discovered that in a document that already references specific files, attempting to change the source, I am directed immediately into the local or network folder structure where the original source file lives, can browse around freely and choose another file.  Unfortunately, that does not work with folders.

 

The same is true whether i be from Power BI or Power Query.

 

Ridiculous and not User-Friendly.

 

No other local Microsoft product that I have does this, except PowerAutomate.  It started this nonsense.

 

It almost seems as if these two pieces of software need to change what folder is the default, or give me something in the optiosn to choose.

 

Excel defaults to Documents and I can browse freely.

Word defaults to Documents and I can browse freely.

PowerPoint defaults to Documents and I can browse freely.

... and the list goes on ...

Idea Statuses