Which Power BI File to Gitignore to Prevent Data Push

Maintain the analytics development lifecycle
Answer Correct answer: B — Reference cache.abf in the .gitignore file to prevent cached data values from data sources from being pushed to the repository.

You have a Microsoft Power BI project that contains a semantic model. You plan to use Azure DevOps for version control. You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference?

  1. unappliedChanges.json
  2. cache.abf Correct Answer
  3. localSettings.json
  4. model.bim

Community Votes

B
100%

100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

This question tests Power BI version control file structures; the common trap is confusing local settings or model metadata with the actual cached data values stored in cache.abf.

When using Azure DevOps for version control with Power BI, preventing data values from data sources from being pushed to the repository requires ignoring the cache.abf file. This page establishes that cache.abf holds the cached data and should be excluded via .gitignore.

Choosing localSettings. because it sounds like it might contain sensitive configurations, but it does not contain the actual data values from the data sources.

Community Discussion (4 comments)

Michal88 👍 1 Selected: C
Explanation: When using Azure DevOps for version control in a Power BI project, you need to exclude sensitive data values (such as connection strings, credentials, and local configurations). The localSettings.json file contains environment-specific settings, including: Local dataset credentials Server connections User-specific configurations By referencing localSettings.json in the .gitignore file, you ensure that sensitive information is not pushed to the repository.
testtaker45 👍 1 Selected: B
Seems like cache.abf is the right answer. It has data values from the data sources, and some other sensitive info you may not want to upload. localfiles.json contains settings specific to the local environment, such as paths or configurations for testing/debugging. Not the data values from the Data Sources.
pk07 👍 3 Selected: B
You have a Microsoft Power BI project that contains a semantic model. You plan to use Azure DevOps for version control. You need to modify the .gitignore file to prevent the data values from the data sources from being pushed to the repository. Which file should you reference? B. cache.abf
pk07 👍 4 Selected: B
B. cache.abf Justification: This file contains the cached data for the semantic model. It is a binary file and can be very large. Excluding this file from version control is necessary to prevent pushing large amounts of unnecessary data, and will prevent data from data sources from being pushed to the repository. Why it's the correct option: Contains the cached data from the data model.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

The cache.abf file contains the cached data from the semantic model's data sources. By adding cache.abf to the.gitignore file, you prevent this potentially large and sensitive cached data from being pushed to the Azure DevOps repository. This is a standard practice for Power BI version control to keep repositories lean and secure.

Why the Other Options Are Wrong

localSettings. contains local user-specific configurations and paths, not the data values from the data sources. model.bim contains the semantic model's metadata and schema definitions, not the cached data. unappliedChanges. tracks local unapplied changes to the model metadata, which also does not include data values.

Community Comment Notes

As pk07 noted, "This file contains the cached data for the semantic model" and excluding it "will prevent data from data sources from being pushed". testtaker45 also pointed out that localSettings. contains "settings specific to the local environment" rather than "data values from the Data Sources".

Official Reference

https://learn.microsoft.com/en-us/power-bi/developer/projects/power-bi-project-overview

Exam Strategy

Know the specific file extensions generated by Power BI Desktop and what data each contains. Remember that cache.abf holds the actual cached data, while model.bim holds the metadata.

Related Analysis

Case study - This is a case study. Case studies are not time

S-Grade

You have a Fabric tenant that contains a Microsoft Power BI

S-Grade

Note: This section contains one or more sets of questions wi

A-Grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide