Forum Discussion

ESE_fh's avatar
ESE_fh
Frequent Visitor
3 years ago
Solved

Get all combined subDirectories with Folder.Contents() from multiple servers (mainDirectories),

Dear Pro-Users, most likely an easy question,  What is a performant PQ best practice to query Folder.Contents (directories only) from different servers/directories? starting from a table with all d...
Show and Tell
  • lbendlin's avatar
    lbendlin
    3 years ago

    No, you need to bring out the big guns.  AD extracts, Purview, Scanner API.  Low code/no code tools tend to be overwhelmed when confronted with massive amounts of data.

ESE_fh's avatar
ESE_fh
Frequent Visitor
3 years ago

Note on the concrete task to be accomplished that appears to be a standard BI use case
Task: Load data from distributed XLS-files (of same kind) from changing (renamed/moved) folders
via PBI (PQ) into a flattened MS-Cube to consolidate file-data for comparative pivot-analysis.

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
Task: Load data from distributed XLS-files (of same kind) from changing (renamed/moved) folders
via PBI (PQ) into a flattened MS-Cube to consolidate file-data for comparative pivot-analysis.

This is from when? 2013 ?