Forum Discussion

MTrullàs's avatar
MTrullàs
Helper III
4 years ago
Solved

Files in SharePoint

Hello,   I have a problem with updating a file from Sharepoint. When I call a folder from Sharpoint in PowerQuery it appears files that they don't exist any more (in yellow). That it's inconveni...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi MTrullàs ,

     

    A couple of things you can try:

     

    1) On the ribbon in Power Query, go to the Home tab > Refresh Preview. This will make sure your PQ preview is showing the latest state of the SharePoint folder.

     

    2) If the files still appear, then in your Explorer window, go to the View tab and put a tick in the 'Hidden Items' box under the 'Show/Hide' section of the ribbon. This will show if these files are actually hidden so not normally visible to you.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi MTrullàs ,

 

A couple of things you can try:

 

1) On the ribbon in Power Query, go to the Home tab > Refresh Preview. This will make sure your PQ preview is showing the latest state of the SharePoint folder.

 

2) If the files still appear, then in your Explorer window, go to the View tab and put a tick in the 'Hidden Items' box under the 'Show/Hide' section of the ribbon. This will show if these files are actually hidden so not normally visible to you.

 

Pete

  • MTrullàs's avatar
    MTrullàs
    Helper III
    4 years ago

    Thanks, with the first shot, it works.