Create automated dashboard/report on powerbi

I need to build a report dashboard using the PowerBi using excel reports from Qualys to create a Vulnerability and Patch Management dashboard. I need report to include metrics for like aged vulnerabilities, weekly/monthly changes and etc.