Edit

Git integration with paginated reports

  • Article

APPLIES TO: Power BI service Power BI Report Builder Power BI Desktop

This article walks you through publishing a paginated report and keeping it in sync with your git workspace. Developers can apply their development processes, tools, and best practices.

Prerequisites

To integrate Git with your Microsoft Fabric workspace, you need to set up the following prerequisites in both Azure DevOps and Fabric.

Azure DevOps prerequisites

  • An active Azure account registered to the same user that is using the Fabric workspace. Create a free account.
  • Access to an existing repository.

Fabric prerequisites

To access the Git integration feature, you need one of the following:

In addition, your organization’s administrator has to enable the Users can create Fabric items tenant switch from the Admin portal.

Screenshot of Fabric switch enabled.

Read about the integration of Git with Microsoft Fabric at Introduction to git integration.

Power BI prerequisites

See the Prerequisites section in Get started creating paginated reports in the Power BI service.

Add a paginated report to GitHub

  1. Connect your workspace to your git repository by following the directions in Connect a workspace to an Azure repo.

    Screenshot of the information to connect to workspace.

    Note

    If the branch is new, you're prompted to Create and sync.

  2. Upload your .rdl file to the workspace on the service. We don't support OneDrive or Sharepoint yet.

    Screenshot of the Upload button.

    After you upload the file, you should see the report and the Git status Uncommitted and Source control.

    Screenshot of status.

  3. Select Source Control. In the source control pane, select the file and commit.

    Screenshot of Commit.

    After you commit the file, the Git status changes to Sync.

    Screenshot of Git Synced.

    A folder appears in your git repository that contains the .rdl and two .json files. You might have to refresh your repository.

    Screenshot of Git repo.

Edit a paginated report that's saved to GitHub

  1. Open the .rdl file from the local git repository in Power BI Report Builder.
  2. Make the desired edits.
  3. Commit and push your changes to the remote repository.
  4. Create a PR to the main branch.
  5. Once approved, the PR is merged to the main branch.
  6. From the main branch, apply your revised changes to the relevant workspace.

Considerations and limitations

  • Publish/upload the paginated report to the service and then use git. Paginated reports don't render if you start with the files in git.

  • When you delete a paginated report from git, delete the entire folder and not just the .rdl report.

  • The paginated report remains connected to the original dataset when you move it to a different workspace. If you move a paginated report to a different workspace, update the dataset in Power BI Report builder and republish the paginated report to the Power BI service.

Next steps