DP-500 Question #144: Real Exam Question with Answer & Explanation

Question

You deploy a tabular model to the Power BI service. The model is developed and maintained by using Microsoft Visual Studio. Power BI connects to the model by using the Connect live option. You need to recommend a source control solution for the model and the report files. What should you include in the recommendation for each type of file? To answer, select the appropriate options in the answer area.

Explanation

The recommended source control solution for both tabular model files and Power BI report files involves using a Git-based repository to manage versioning and facilitate collaborative development.

Approach. For the tabular model files developed in Microsoft Visual Studio, a distributed version control system like Git (e.g., Azure DevOps Repos, GitHub) is ideal. Modern tabular model definitions (.bim files) are JSON-based and inherently text-based, allowing Git to provide granular version history, diffing, branching, merging, and rollback capabilities essential for team development. For the Power BI report files (.pbix) that connect live to the tabular model, these files primarily contain report definitions and visualizations without the underlying data model. While .pbix files are binary (ZIP archives), storing them in a Git repository still offers crucial version history and the ability to revert to previous states. Although Git's advanced diffing and merging capabilities are limited for binary files, the version tracking and centralized repository benefits remain significant. For enhanced collaboration and more granular source control, Power BI's Git integration feature (which externalizes report definitions into text-based files) can be leveraged, offering a superior experience for diffing and merging report changes.

Concept tested. Application Lifecycle Management (ALM) for Power BI and Analysis Services Tabular Models, focusing on source control best practices for different asset types.

Reference. https://learn.microsoft.com/en-us/power-bi/developer/portal/integration-git

No community discussion yet for this question.