Forum Discussion

LMCarlson_ABB's avatar
LMCarlson_ABB
Frequent Visitor
2 years ago

Changing from Folder.Files to Folder.Contents causes error

In the following query, if Folder.Files is changed to Folder.Contents, the following error is reported. What is the cause and what is the remedy?   An error occurred in the ‘Transform File (3)’ que...
Need Help
VN999's avatar
VN999
Resolver I
2 years ago

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.