load data from sharepoint folder

[Jeanxyz]

I want to load four xlsx files stored in a sharepoint folder (see printscreen). In Power BI, I chose Get Data-Sharepoint Folder. Under the data transformation tab, I see lots of files stored in root url, but after filter file names, I only find one file in the sharepoint folder where the four documents are stored.

I couldn't figure out where the other three files are gone. Although I know that these four documents are exactly the same, so the same files might be loaded four times to sharepoint. but still, I expect to find 4 files in that sharepoint folder.

Regards,

Jean

[Anonymous]

Hi @Jeanxyz ,

You should click the double down arrows to load the excel file.

Here's the article you can refer to.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Jeanxyz do you have any other filter in PQ? Seems like the other 3 files are recently copied, can you refresh the preview to see if that updates the list?

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  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.⚡