Reference isn't valid

Hi LissethV ,

Please refer to the similar post:

Solved: Expression.Error: We cannot convert a value of typ... - Microsoft Power BI Community

This error occurs when your "Parameter1" is type Table and not type Binary.

Excel.Workbook - PowerQuery M | Microsoft Docs

You would try to add File.Contents() to convert it to binary.

Best Regards,

Stephen Tao

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