Forum Discussion
Power BI Get Data using Powershell
Hey portnerr ,
the answer is, unfortunately, quite simple - you can't invoke Powershell from inside Power BI / Power Query.
Here I started to describe a solution I'm currently building:
An essential part of this solution is also Powershell, but it is not invoked by Power BI.
For this reason, you have to re-think your solution, create data using Powershell, and then use Power BI to pick-up the data.Regards,
Tom
Super UserHey portnerr ,
the answer is, unfortunately, quite simple - you can't invoke Powershell from inside Power BI / Power Query.
Here I started to describe a solution I'm currently building:
An essential part of this solution is also Powershell, but it is not invoked by Power BI.
For this reason, you have to re-think your solution, create data using Powershell, and then use Power BI to pick-up the data.
Regards,
Tom
Thanks Tom! Not the answer I wanted, but it is what it is. I did think about using 2 steps. Run the script, import the data, but wanted it to be one process. Oh well. Thanks again.
