I am reasonably new to power bi. I am trying to invoke PowerShell from Power BI and I do not see it as a data source in the get data list. I am NOT trying to invoke the Power BI Admin functions/commands, 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 with all of the end points you can use to get data. :-)
Does anyone know of a "clear" reference on how to do that.
Thanks