Forum Discussion

SANTOSAlex's avatar
SANTOSAlex
New Member
8 months ago
Solved

Carregamento via Pasta do Sharepoint

Tenho enfrentado dificuldades em baixar no power query, a pasta do Sharepoint que preciso. Quando utilizo o filtro para buscar o arquivo dá como se ele não existisse. O que posso fazer para conectar ...
  • v-sgandrathi's avatar
    8 months ago

    Hi SANTOSAlex,

     

    Thank you for clarifying.

    Since you are using SharePoint Online and have limited access to specific folders, this behavior is normal. The SharePoint Folder connector only shows files from folders you can access. If you do not have at least read access to a folder, files inside it will not appear when filtering, even if other files load.

    For scheduled refresh, use the SharePoint Folder connector (the Web connector does not support this well). Connect using the root site URL, then filter with the Folder Path column to the folder you can access. Filter by folder first, then by file name.

    If the file still does not show up, check with your SharePoint administrator to confirm:
    Your access to the folder
    The file is not checked out or restricted
    The folder is not in a library with special permissions

    Once permissions are confirmed, scheduled refresh should work without needing a gateway.

     

    Thank you.