What is the optimal approach we should follow to test data in Power BI Dashboards and reports ? Example, if reports are built using SQL Server as source , How do we validate data in each visual? How to do we validate data model correctness?How do we test the performance of reports agains production data?
The question is more around the process we follow for data validation and performance, example if I need to validate chart in Power BI , I prepare equivalent sql statement which includes the columns used in chart and validate results between chart and sql database. For Data Model, I validate each and every metrics across all dimensions by running sql statements against database to make sure metrics shows correct result across dimensions. For performance, I use performance analyzer to check which area ( charts , calculations etc.) is taking more time. is this the correct approach?
