Errors on dataflow created using sharepoint folder data

[qsong]

Hi PBI Community,

Recently the dataflows I created before stopped working. The reason was that "The field 'Hidden' of the record wasn's found". I do not quite understand the meaning of the error message, especially I just got it from the dataflows which worked well in the past. My question is how to fix them.

Also I tried to create a dataflow again to replace the old one which does not work now.  I used two ways to deal with it, and none works for me:

1) I created the dataflow linked to data source - sharepoint folder. When I combined all excel files in the folder, I got error message - unexpected error;

2) I created the dataflow by pasting M queries from desktop version to the blank query of the dataflow. I had the same error message - "The field 'Hidden' of the record wasn's found".

I appreciate any assistance for that.

[v-lili6-msft]

hi  @qsong 

It seems that 'Hidden' field has been removed or renamed. please click each step in the right pane in power query to see this error happens on which setp.

Regards,

Lin

[qsong]

Hi Lin,

My dataflow has the following steps:

1) data source: sharepoint folder

2) filter rows: a specific folder path

3) filter hidden files: it is an automatic step when I decide to combine all excel files in the specif folder by clicking double arrow sign of the content column

4)...

The error message comes out in the third step: it seems that it rejects to combine all excel files. I do not know why it happens now. Do you have any idea about it and how to fix it? 

Thank you. 

[pat_mecee · Accepted solution]

Please check this thread for your solution.

https://community.powerbi.com/t5/Issues/DataFlow-refresh-issues-with-Sharepoint-Online-folder-source...