The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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.
I've been having the same problem since this morning.
Same issue here
Myself aswell, for a couple of days now. All of my dataflow refreshes are failing.
Did the issue happen when you refreshed the dataflow? Did the dataflow require any gateway?
Please check if you encounter the issue listed here:
Best Regards,Qiuyun Yu
No need for gateway -> the csv files are located on Sharepoint.
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.
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.
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):
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!
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.