Forum Discussion
Getting error when trying to combine files from a folder
Hi Archie2024 ,
-Add custom column, entered Excel.Workbook[Content]
Please try this:Excel.Workbook([Content])[Data]{0}Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
I really appreciate everyone's help! That worked! Thank you!
Hi, thank you for your response.
Here are the steps I took:
Yes, from combine and transform
- Get data> folder
- both files were loaded
-I hit transform
-I removed the other columns, and kept colums Content (Binary) and Name(payrolldata..)
-Add custom column, entered Excel.Workbook[Content]
And that where the column came up with the error msg. Seems like only one table were loaded.
Expression.Error: We cannot apply field access to the type Function.
Details:
Value=[Function]
Key=Content
Hi Archie2024 ,
-Add custom column, entered Excel.Workbook[Content]
Please try this:Excel.Workbook([Content])[Data]{0}Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
I really appreciate everyone's help! That worked! Thank you!
Excel.Workbook([Content])
