Calling external DLL in Power Query

[BoNiko]

Hi everyone!

Is it possible to run external dll (.NET) from Power Query within the Power BI Desktop?

Thanks!

[MikeJohnsonZA · Accepted solution]

No, it would not be possible to call it directly, 

You may be able to call it using a python script (Meaning you would require a gateway in personal mode to run), Or you could create a simple .net API that you could call as RESTservice.....

Or use another tech like SSIS to consume the API then store the results in SQL then read the results from there. 

The power BI security model would not allow for execution of DLL's

[BoNiko]

Thanks! 

With python works fine. I already checked it and with the package "pythonnet" you can call every method of the dll bibliothek. I want to avoide the usage of any additional software.