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

Thank you for the VertiPaq hint, indeed helpful/new.
You may want to continue exploring other tools?
It means power platform apps/page/automate/va, eventhub/dataverse...?
Coming py/R/SQL/git, MS strongly adviced no/low-Code power platform.

lbendlin's avatar
lbendlin
Super User
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

    Thanks again. Issue closed Please note: Process is exactly designed to avoid massive data.
    The select process serves the purpose to select only those few files (data) of current interest.
    There is just no singel point of truth SPOT, since files flaot on file server.

    This fact requires iterative (therefore performant) folder search (folder browsing).

    Hypothesis: Many SMEs should face a similar situation, (i.e. money on the street?)