I am reasonably new to Power BI. I am trying to invoke PowerShell from Power BI. I do not see it as a data source in the get data list. I am trying to use PowerShell to get data/work items from Microsoft Service Manager for metrics reporting.
I have a Powershell script the queries data from Service Manager and exports it as a comma delimited Flat file that I was able to "get data" from that file into power BI manually.
I can find no articles/information on just invoking a PowerShell from Power BI which seems like a straightforward thing to do using Microsoft products. . 🙂
Does anyone know of a "clear" reference on how to do that.
Thanks