How to reference Excel-DNA and call Excel-DNA functions from Power Query?

[Sergey Getman]

Is it possible to call Excel-DNA funcitons from Power Query?

When I try to call my Excel-DNA function in my M query like this:

"

#"Invoked Custom Function" = Table.AddColumn(Source, "RunShowCategories", each ExcelDnaUtil.Invoke("RunShowCategories", [TreeFullPath])),
"

I get the next error: "Expression.Error: The name 'ExcelDnaUtil' wasn't recognized.  Make sure it's spelled correctly."

At the same time I am able to call my RunShowCategories Excel-DNA function from the same Excel worksheet where I have the above M query without any problems, because I referenced my .xll as an Excel addin already.

Please explain how to call Excel-DNA functions from Power Query correctly. 

[Govert van Drimmelen]

I don't think this is supported by Power Query.

-Govert

[Sergey Getman]

That is a pity, but thank you for the clarification, and there is a work-around for that anyway.