Changing from Folder.Files to Folder.Contents causes error

The error message "Expression.Error: The parameter is expected to be of type Text.Type or Binary.Type" typically occurs in Power BI when there is a mismatch in data types during transformations or when using a function that expects a specific type of input.

Here are a few steps to troubleshoot and fix this issue:

Step-by-Step Troubleshooting:

1. Identify the Source of the Error:

   • Go to the Power Query Editor by clicking on "Transform data" in the Home tab.
   • Look for the query named 'Transform File (3)'.
   • Check the applied steps in the query settings pane to identify where the error occurs.

2. Check Data Types:

   • Ensure that the columns used in the transformation are of the correct data type (Text.Type or Binary.Type).
   • If necessary, change the data type by selecting the column and then using the "Data Type" dropdown in the Transform tab.

3. Review Applied Steps:

   • Go through each step in the query to find where the type mismatch occurs.
   • If you find a step that applies a function expecting text or binary data but receives a different type, correct the data type before this step.