Exporting usable Performance Analysis reports or PowerBI

tpgraham

Hello all,

I am new to this community and was pointed to it by a question I had posed on Twitter. I am looking to get weekly analysis reports out to our hosted clients. As part of that communication I want to show them CPU/RAM usage and storage trends and the PerfStack Analysis produces great reports for this, but I cannot do anything with them. If I export I get a generic CSV dump and sharing simply generates a URL that is not accessible to my clients. I am starting to look at integrating it with PowerBI but I have no idea where they are storing the historical analysis data. Has anyone successfully done this?

Thanks in advance.

cha-chang_

This is only a partial answer to your multiple-part question, but there are options.  You can generate periodic reports and send them out to a D/L.  You can create it within the SW interface REPORTS | ALL REPORTS | MANAGE REPORTS.  Or you can use REPORT WRITER off of the poller to customize one. 

I have not looked into the PowerBI option.  Perhaps someone will be able to answer that here.  However, if you want to know where a saved chart is, you can access the DB and locate the table called [PerfStackProjects].  You will find the saved chart there.

Hope this helps