Status:
New
DataFlow refresh issues with Sharepoint Online folder source
Our DataFlows that are reading Excel and CSV files off of Sharepoint Online folder (document library) have all begun failing to refresh this week. Most of the errors seem to indicate some connecti...
We have a similar problem Anonymous, anselmojg , pat_mecee , a colleague of mine spotted ourshaving problems with "Filter Hidden Files".
The power query function is
Table.SelectRows(#"Filtered rows 1", each [Attributes][Hidden] <> true)
We removed those filters (which are automatically generate via the UI), via the UI and ours now refresh.
I have been unable to create a new dataflow that performs a combine on a Sharepoint files. As i stated the UI is automatically generating the filter on hidden files and it causes any new query to fail, complaining about the hidden attributes.
Here is another link confirming the same.
I am not sure if yours are similar but you can look to see if your dataflows have that filter condition.