Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

ncbshiva

Dataflows with Excels are failing with "The field 'Hidden' of the record wasn't found"

Submitted by Advocate V on ‎04-29-2020 02:24 AM

Hi All,

 

Since today's morning my dataflows are failing with below error message and my source are excel files.

 

Expression.Error: The field 'Hidden' of the record wasn't found.

Details
Size = 20335449
Content Type = application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind = Excel File
Status: New
See more ideas labeled with:
14 Comments (14 New)
Comments
Anonymous
Not applicable
‎04-29-2020 04:07 AM

I've been having the same problem since this morning.

Anonymous
Not applicable
‎04-29-2020 09:17 AM

Same issue here

sharpy86
Regular Visitor
‎04-29-2020 06:44 PM

Myself aswell, for a couple of days now. All of my dataflow refreshes are failing.

v-qiuyu-msft
Community Support
Community Support
‎04-29-2020 08:15 PM

Hi all,

 

Did the issue happen when you refreshed the dataflow? Did the dataflow require any gateway? 

Please check if you encounter the issue listed here: 

 

q3.PNG

 

Best Regards,
Qiuyun Yu

 

 

Anonymous
Not applicable
‎04-29-2020 11:25 PM

No need for gateway -> the csv files are located on Sharepoint.

ncbshiva
Advocate V
Advocate V
‎04-30-2020 12:10 AM

Gateway is not required as we are refreshing the excel files stored in the SharePoint.

Not sure if any metadata has been changed in the SharePoint.

Anonymous
Not applicable
‎04-30-2020 12:12 AM

We are having same issue. 

 

 

Yesterday evening all was working but this morning none of dataflows are loading data and they get stuck on the step mentioned.

 

Error> The field 'Attributes' of the record wasn't found.

Anonymous
Not applicable
‎04-30-2020 12:40 AM

It seems that something changed on the Sharepoint side and it is no longer passing on the Hidden variable in the files attributes. Here is a workaround that worked for us assuming there are no hidden files in the filter/folder:

Leave out this line in the main query (obviously you have to also update the reference in the next step): 

 #"Filtered hidden files" = Table.SelectRows(Uroven2, each [Attributes][Hidden] <> true)
 
And also same logic has to be used (leave out the hidden files filter) in the Sample File helper query.
Anonymous
Not applicable
‎04-30-2020 01:25 AM

Hi again,

 

We followed the advice given by Miloslav and it worked. It was about to remove the  #"Filtered hidden files" step and that's it.

Don't understand why and what happened, but it works!


Thanks!

sharpy86
Regular Visitor
‎04-30-2020 08:25 PM

Brilliant, this worked for me! Removed the #"Filtered hidden files" line entirely, and updated the reference on the row below. 

 

Now the queries are refreshing.

 

Thank you Miloslav!

Idea Statuses