PQ Issue: Cannot Convert type Table to Type Binary

[Pulsar3000]

Hello Everyone:

I have a power query with a dynamic file path to get a set of files from one folder. The files only have one sheet but the sheets have different names.
I'm trying to make my file path to work but get the error: We cannot convert a value of type Table to type Binary.

Here's the majority of the M code for "Other Queries" and note that the FolderPath in the first line is a named range for one cell only that contains a link.

Here's the M code for the Sample File. The item in orange is not literal. My real M code has the entire actual path of where the folder is located but didn't want to provide it for privacy reasons.

let
Source = Folder.Files("ACTUAL FILE PATH"),
Content0 = Source{0}[Content]
in
Content0

Can someone help me troubleshoot? Thanks in advance for your help!

 

[GraH]

Hi,
In the second step you have the function Excel.Workbook. that function takes a binary (file) as input, but the output is a table.
However you have nested Folder.Files, which returns a table.

You probably have in this table a list of Binary files on which you want to invoke a function to get to the content of the binaries through Excel.Workbook.
It's likely you already have that in the Invoke Custom Function step.

Try leaving your source step as Folder.Files(Path).

 

[Pulsar3000]

Hi,
In the second step you have the function Excel.Workbook. that function takes a binary (file) as input, but the output is a table.
However you have nested Folder.Files, which returns a table.
View attachment 107780

You probably have in this table a list of Binary files on which you want to invoke a function to get to the content of the binaries through Excel.Workbook.
It's likely you already have that in the Invoke Custom Function step.

Try leaving your source step as Folder.Files(Path).

Thank you so much!! That worked.

 

[GraH]

Thank you for the feedback. Glad to help.