cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
dancarr22 Member
Member

Connecting to 'Folder' from desktop just to get info on folder contents - extremely slow

Hello,

 

We are testing Power BI to see what details it can provide about folder/subfolder/files.

So, pretty simply, pointing to a folder (in Get Data) and trying to get info about the contents of those folders.  We do not need to interrogate the contents of those underlying files.  Just need to know attributes/metadata about the file - name, folder, extension, size, last time accessed, etc.

This is extremely slow and takes several hours to run.  All we want is the metadata/properties of each file.  Is there a setting or way to do this so it runs quicker?  We do have ~40k underlying files but it took ~6 hours to run and load.  This was just one folder structure.  

 

Thanks for any help you can provided,

Dan

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Connecting to 'Folder' from desktop just to get info on folder contents - extremely slow

Use PowerShell, this isn't really a use case Power BI was designed for. I've written multi-threaded PowerShell to scan folder structures and that's a much better tool for the job. User PowerShell to generate a CSV file of the metadata and import that into Power BI. You are trying to use a miter saw to hammer a nail.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


2 REPLIES 2
Super User
Super User

Re: Connecting to 'Folder' from desktop just to get info on folder contents - extremely slow

Use PowerShell, this isn't really a use case Power BI was designed for. I've written multi-threaded PowerShell to scan folder structures and that's a much better tool for the job. User PowerShell to generate a CSV file of the metadata and import that into Power BI. You are trying to use a miter saw to hammer a nail.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


minhvuong93 Regular Visitor
Regular Visitor

Re: Connecting to 'Folder' from desktop just to get info on folder contents - extremely slow

@Greg_Deckler  Do you mean using PowerShell to scan Excel files and convert into metadata CSV files?

Because I have the exact  issue. Huge Excel files as data, updating monthly, and powerbi refreshes all the data sources from the beginning which took forever

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 39 members 935 guests
Please welcome our newest community members: