Hi All
I have a problem with my dataflow, it was working fine until yesterday and now it keeps failing.
I've created a connection using SharePoint.Files( "", [ApiVersion = 15] ) this was...
Same problem with Dataflows (PRO version) connecting to SharePoint files (csv and xlsx). On 5 February 2020 all was ok. On 6th it failed. In Desktop all was still OK.
I have done several tests:
1/ moving files to another folder of the same Sharepoint: still failing
2/ moving files to another Sharepoint (which does not contain many files): The files then became accessible again!
Power Query online therefore seems to have limitations on the number of addressable files (only the 1005 oldest items from the SharePoint appears to be availaible).
As a temporary (or maybe definitive) solution, I moved the requested files to a newly created SharePoint site and changed the data source to this new SharePoint and now it works fine!