files missing from sharepoint folder ONLY when using PQ in dataflows

Im having the same issue at the moment which is really frustrating

I found a work around that seems to be working for while the other method doesnt seem to work

You can use SharePoint.Contents instead.. Then you have to drill through each folder to your folder contents

let
Source = SharePoint.Contents("https://xxxx.sharepoint.com/sites/xxxx/", [ApiVersion = 15]),
#"Shared Documents" = Source{[Name="Shared Documents"]}[Content],
#"Reporting & Analysis" = #"Shared Documents"{[Name="Reporting & Analysis"]}[Content]
in 
#"Reporting & Analysis"

This works if you have all the source files in one directory. You'd have to do some more work if you have subfolders as well because you'd need to navigate through