Has anyone created an SCSM report for Business Services and Related computers?
Looking to use out of the box features in report builder in Power Bi. Is it possible without writing SQL queries?
Wanted to have a report that listed Business Services with related computers and their owners.
We bring services in from SCOM.
Has anyone tried this?
Answers
There is no reason you shouldn't be able to pull this off with PowerBI and avoiding writing SQL queries. You will still have to perform joins, but they'll be done entirely through the PowerBI UI instead of SQL.