Automated creation of service requests

Hello All!
We have a procedurally generated power BI report that contains a list of vulnerabilities(out of date software ect) per machine.
For our analysts we create tickets 1 per vulnerabilities so if 100 machines have out of date (adobe) for example it will create 100 tickets to patch them(we try to automate using sccm ect)
My question: Is there a way(preferably using power BI) but if not then exporting a report to excel and then using PowerShell(or I see a beta web-hooks available) to generate tickets from a list?
IE take this +100 other entries(The powershell script would take the info from an excel sheet in the same folder):
The result would be:
Thank you all for any help! Hoping automated ticket generation is a popular request or there is way to do so in power BI !
Answers
What is the source of the Power BI report?
The sources of the power BI report are service management and service manager (we used both depending on the objective)
So then the source is a SQL database, use the same rules in for PowerBi and build a SCORCH runbook to create matching work items.
I was thinking that but - apologies for not mentioning- Some of the sources are also being tied in from rapid7,ATP, CISA , ect - as we wanted a very comprehensive report.
Hence the question on how to create tickets in scsm using the power bi report or failing that exporting what we want and then running a script to generate tickets
Power BI -> export list to excel -> run script -> generate SRs for analysts - Unless Orchestration Console can do that?
We also have outside systems that provide reporting that I cannot hit directly, aka receiving reporting with csv's. So to address that have power automate capturing the files and moving them into a custom SQL database. Then combining the OOB databases and these custom databases we run rules that create 100's of tickets each month of "issue assets"
Since Power Automate can "Talk" with Power Bi you might be able to have Automate perform the export job as a flat file, copy to a local file share, then call SCORCH RestAPI to kick off a runbook to process that export file.
HTH
Historically my advice would have been any one of the following (obviously varies based on specific use case):
HOWEVER!
Per our Innovate 2022 announcement yesterday - with the upcoming release of our Power Automate Connector for SMP, I can't see why you now couldn't potentially use Power Automate's Power BI connector to extract data and then drive the creation of Incidents/Service Requests entirely from Power Automate.
Hello,
I attended the Innovate 2022 announcement! :)
I am very excited to use power automate -> however -> Is there an expected release date?
Thank you for replying!