Forum Discussion
Reference isn't valid
Problem with the connection. i have a huge report which is getting delay 😞 need helpp!!
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.
4 Replies
Hi LissethV ,
Based on the limited information, it is not easy to trace the error. Reference is not valid, and you may want to go through the "Transformation sample file" to see if you're able to see any reference codes required to update, such as worksheet name.
Regards
KT
Hi KT, Thanks for your reply.
Below is the error i have
Have you checked if any other files in the folder are legit?
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.
