Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Steps to add folder access using on-premises gateway

Hi Guys, my query looks like: let CleanPath = Text.Trim(paramLocalRepositoryPath & "/" & paramRepository), Check = try Table.RowCount(Folder.Files(CleanPath)) otherwise 0, isValid = ...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi jaryszek ,

    Thank you for engaging with the Microsoft Fabric Community.

    1. Use the UNC path (MyFileServer\RepoRoot) instead of a mapped drive. Power Query’s Folder.Files function will then return every file in that folder and all nested subfolders, so you don’t need to register each subfolder separately.

    2. Add the folder path as a Folder data source in the Manage Gateways section, and use Windows auth. If the password changes, make sure to update it in the gateway to avoid refresh failures.

     

    reference: Folder.Files - PowerQuery M | Microsoft Learn

     

    If my response solved your query, please mark it as the Accepted solution to help others find it easily.

    And if my answer was helpful, I'd really appreciate a 'Kudos'.

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi jaryszek ,

Thank you for engaging with the Microsoft Fabric Community.

1. Use the UNC path (MyFileServer\RepoRoot) instead of a mapped drive. Power Query’s Folder.Files function will then return every file in that folder and all nested subfolders, so you don’t need to register each subfolder separately.

2. Add the folder path as a Folder data source in the Manage Gateways section, and use Windows auth. If the password changes, make sure to update it in the gateway to avoid refresh failures.

 

reference: Folder.Files - PowerQuery M | Microsoft Learn

 

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.