Reference isn't valid

[LissethV]

Problem with the connection. i have a huge report which is getting delay 😞 need helpp!! 

[Anonymous · Accepted solution]

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.

[KT_Bsmart2gethe]

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

[LissethV]

Hi KT, Thanks for your reply.

Below is the error i have 

[KT_Bsmart2gethe]

Have you checked if any other files in the folder are legit?