I would like to know QA process set up for this ETL testing and PowerBi testing.
Don’t know if these are helpful. If it doesn’t make sense, please let me know.
I think it’s similar to web testing - the front end bit (the report / web GUI) is harder to test than the back end (ETL / API).
Also, it might help to think about what you consider valuable about the ETL pipeline, so you can direct your testing there. This might help: Mental models for data processing – Random Tech Thoughts
Where it comes to the reports part, rather than the data processing part, the best I can offer is at a fairly high level. Why does the report exist? What business problem does it solve, and for whom? Once you’ve identified those, how well does the report solve those problems? Visualisations and the stories behind them – Random Tech Thoughts