Forum Discussion

qsong's avatar
qsong
Helper II
6 years ago
Solved

Errors on dataflow created using sharepoint folder data

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 ...
Dataflow
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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's avatar
    qsong
    Helper II
    6 years ago

    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.