Combine excel files preventing publishing app

[PowerBITestingG]

I am using a default transform function to combine excel files from one folder. For some reason this is preventing me from publishing an app due to Parameters of type any or binary not supported.

Is there a simple way to fix this?

Thanks!

[Anonymous]

Hi @PowerBITestingG ,

I have a few questions about your description:
1. Whether the data source used is only Excel.
2. What operations were performed in the query editor.
3. Whether the Power Query parameter is applied (what is the setting type and where is the application).
4. The error message uses a type that ANY or binary does not support, can it be changed to the Text type. If you can, whether you can publish the APP normally after the change.
5. Please refer to the documentation to check if the restrictions are violated.

You can refer to the following posts that may be helpful to you:

Solved: how to Combine excel files - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.