SharePoint Folder connection not showing all files

[tkxd64]

I have a particular excel file saved in Sharepoint.

But when I tried to get data using SharePoint connection, that particualar file is not showing in the list.

[tkxd64 · Accepted solution]

I was able to find the answer. Name column>filter text>contain>type the name of filename. 

Using this, I'm able to find the file I'm looking for. 

[v-cazheng-msft]

Hi, @tkxd64 

Have you ever checked your access to this excel file in SharePoint? For the files in SharePoint, you need proper access to visit them.

For more details about getting data with SharePoint Folder, you can refer import And Exporting Data From SharePoint And Excel.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@tkxd64 check this post

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡