Forum Discussion
Solved
Data quality/validation in reports - Power BI
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 h...
Hi disney_batista ,
The answer to your question may be really extensive, but to summarize:
- 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 - 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-pipelines?tabs=from-fabric%2Cnew%2Cstage-settings-new
Memorable Member | Former Super User
If I helped, please accept the solution and give kudos!
Linkedin- 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.
lbendlin
Super User
Super UserWhat is your focus? Data changes, semantic model changes, other meta data changes, or rendering changes?
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.
