Forum Discussion
Expression Error: The Type specified wasn't recognized. Dataflow Cust Function
Good Day, I created a function in PBI Desktop Query Editor. and it works fine to process the files. Then I copied this function in a Dataflow which was okay. but when I invoke the function in the dataflow to add a New column, and pass the required input which is binary content; I get this error. I tried googling but couldn;t find anything useful.
Would really appreciate if anyone can advise how to fix this.
try without the "as table" part
(Filebinary) =>
4 Replies
what type did you specify? Please show the relevant bits of your Power Query code.
Hi, here's the power query code:
(Filebinary as binary) as table=>
let
Source = Excel.Workbook(Filebinary),#"Cost_Sheet" = Source{[Item="Cost Info",Kind="Sheet"]}[Data],
#"Removed Top Rows" = Table.Skip(#"Cash_Sheet",91),
#"Removed Other Columns" = Table.SelectColumns(#"Removed Top Rows",{"Column2", "Column3", "Column4", "Column5", "Column6", "Column7"}),
#"Kept Range of Rows" = Table.Range(#"Removed Other Columns",0,3),
#"Promoted Headers" = Table.PromoteHeaders(#"Kept Range of Rows", [PromoteAllScalars=true]),
in
#"Promoted Headers"try without the "as table" part
(Filebinary) =>