HI I want to create BI dashboard for Security Data ( vulnerability Management) and my data keeps on changing as per the new issues and upgrades. of operating System. How should I plan to show historical data also in my live Power BI Dashboard?
I am pulling the security reports everyday in my SQL DB and connecting the same to Power BI however, I want to show as of today status along with last one month progression in same same chart.