Cannot get the newest files from Sharepoint Folder since May 2nd 2024

[pandamoon]

I got a problem where I cannot get newest shared files from Sharepoint Folder data source since May 2nd 2024. I've already checked that there is no changes in permission before/after May 2nd. In that shared folder through Sharepoint web, there are many files that have created since that day but still not detected in Power Query, even I refreshed all my data.

I'ved tried these but still no differences:
- Log out and log in my user then refresh again
- Edit/clear permission in Data Source Settings, even using another accounts that have permission to access the shared folder
- Create new query, but still same output (max 02/05/2024)

Here my screenshot from Power Query

Is there any clue with this problems? Thank you

[v-tianyich-msft]

Hi @pandamoon ,

My attempts to connect have failed to reproduce your problem. But as you can see from the image there is a record of changes made on June 5, can you make sure there is a record of creation on May 2? Or is there a date restriction in your query.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[pandamoon]

Hi @v-tianyich-msft 

There is no date restriction in my query, as in my screenshot, it's in 2nd step of my query, to sort the date creation to newest-oldest. Here I attach 1 sample file that created 6 days ago, and screenshot after I refresh my query to get the newest data.

Here's the sample file inside my shared Sharepoint folder

And here's the refreshed query's result. Still same

[amitchandak]

@pandamoon , Please log an issue too https://community.powerbi.com/t5/Issues/idb-p/Issues