Solved: Calling external DLL in Power Query

BoNiko · ‎01-12-2022

Hi everyone!

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

Thanks!

MikeJohnsonZA · ‎01-13-2022

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

View solution in original post

MikeJohnsonZA · ‎01-13-2022

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 · ‎01-13-2022

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.