Data quality/validation in reports - Power BI

[disney_batista]

Is it possible to implement unit, interface, integration or other types of testing in Power BI?
What strategies are recommended to ensure quality in Power BI?
Is there a way to track what changes have been made to a file?

[lbendlin]

What is your focus?  Data changes, semantic model changes, other meta data changes, or rendering changes?

[disney_batista]

Monitor different types of changes as much as possible. Today I work with a model report and then deploy it to clients. Sometimes in the middle of the process there are changes in the data that I can't map or changes in the filters of the pages/visuals. To ensure data quality, I currently have to compare the staging version with the production version page by page.
If you can tell me which tools/tests you know about, I can apply them according to my needs.

[lkalawski · Accepted solution]

Hi @disney_batista ,

The answer to your question may be really extensive, but to summarize:

1. Yes, you can monitor and save changes that have been made to a file (model or graphic page) - this can be handled using Azure DevOps, which processes all of this, and then you need to enable synchronization with workspaces.
   Link: https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-build-pipelines
   
   You can also use file synchronization on Sharepoint for this - it is a kind of work around, but the change history will also be taken into account.
   Link: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sharepoint-save-share
2. Currently, in Power BI in deployment pipelines you can create from 2 to 10 stages, so the answer to your question is yes, you can.
   Link: https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipel...

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin