Has anyone had any luck using PowerBI with Icinga to get some reports, for statistics primarily, for example, amount of alerts per week, then further filtering. The goal is to have some reporting. I have checked the reporting module that is available but I am looking for something else.
If it is possible, would using an API from PowerBI be best or to query the MYSQL directly from PowerBI. I am new to PowerBI but have been asked to provide some stats and we have the PowerBI platform ready to be used. I had a look on in the internet but didn’t find much so perhaps what I am asking is unreasonable.