Home Business Intelligence Integrating Energy BI with AzureDevOps (Git), half 1: Cloud Integration

Integrating Energy BI with AzureDevOps (Git), half 1: Cloud Integration

Integrating Energy BI with AzureDevOps (Git), half 1: Cloud Integration


Energy BI is a robust device for creating and sharing interactive knowledge visualizations. However how are you going to collaborate with different builders in your Energy BI initiatives and guarantee high quality and consistency throughout your experiences? On this sequence of weblog posts, I’ll present you methods to combine Energy BI with Azure DevOps, a cloud-based software program improvement and supply platform. We will combine Azure DevOps with Energy BI Service (Material) in addition to Energy BI Desktop.
The present put up explains methods to arrange Azure DevOps and join a Energy BI Workspace.
The following weblog put up will clarify methods to apply it to your native machine to combine your Energy BI Desktop initiatives with Azure DevOps.

Earlier than we dive into the main points of Energy BI and Azure DevOps integration, let’s take a second to know what supply management techniques are and why they’re important for any software program challenge.

Supply management techniques, also referred to as model management techniques or revision management techniques, are instruments that assist builders handle the modifications made to their code over time. They permit builders to trace, evaluate, and roll again modifications when crucial and collaborate with different builders on the identical challenge.

There are two most important kinds of supply management techniques: centralised and distributed. Centralised supply management techniques use Shopper-server strategy to retailer all of the code and its historical past in a single server, and builders want to connect with that server to entry or modify the code. Examples of centralised supply management techniques are Microsoft’s Staff Basis Server (TFS) which rebranded to Azure DevOps Server in 2018, IBM’s ClearCase, and Apache’s Subversion.

Alternatively, distributed supply management techniques use a peer-to-peer strategy, permitting every developer to have a neighborhood copy of your complete code repository, together with its historical past. Builders can work offline and sync their modifications with different builders by means of a distant server. Examples of distributed supply management techniques are Git Software program and Mercurial, which takes us to the following part. Let’s see what Git is.

Git is without doubt one of the world’s hottest and extensively used distributed supply management techniques. It was created by Linus Torvalds, the creator of Linux, in 2005. Git has many benefits over centralised supply management techniques, corresponding to:

  • Pace: Git is quick and environment friendly, performing most operations regionally with out community entry.
  • Scalability: Git can simply deal with giant and complicated initiatives, because it doesn’t depend upon a single server.
  • Flexibility: Git helps varied workflows and branching methods, permitting builders to decide on how they need to organise their code and collaborate with others.
  • Safety: Git makes use of cryptographic hashes to make sure the integrity and authenticity of the code.
  • Open-source: Git is free and open-source, that means anybody can use it, modify it, or contribute to it.

Whereas Git is fairly good, it has some disadvantages in contrast with a centralised supply management system. Listed here are some:

  • Complexity: Git has a steep studying curve, particularly for customers who’re new to distributed model management techniques. Understanding ideas corresponding to branching, merging, rebasing, and resolving conflicts might be difficult for inexperienced persons and typically even seasoned Git customers.
  • Collaboration challenges: Whereas distributed model management techniques like Git allow simple collaboration, they’ll additionally result in collaboration points. A number of builders engaged on the identical department concurrently might encounter conflicts that should be resolved, which may introduce complexities and require additional effort.
  • Efficiency with giant repositories: Whereas Git performs fairly effectively on most operations, it could possibly get abortive when working with giant repositories containing many recordsdata or a protracted historical past of commits. Operations corresponding to cloning or trying out giant repositories might be time-consuming.

Azure DevOps is Microsoft’s cloud-based platform offering a set of instruments and companies for software program improvement. It encompasses a spread of capabilities for managing, planning, creating, testing, and delivering software program purposes. Azure DevOps affords:

  • Azure Boards: A device for planning, monitoring, and managing work objects, corresponding to consumer tales, duties, bugs, and so on.
  • Azure Repos: A device for internet hosting Git repositories on-line, which is the principle focus of this weblog put up.
  • Azure Pipelines: A device for automating builds, checks, and deployments.
  • Azure Take a look at Plans: A device for creating and working handbook and automatic checks.
  • Azure Artifacts: A device for managing packages and dependencies.

Azure DevOps additionally integrates with different instruments and platforms, corresponding to GitHub, Visible Studio Code, and now, Energy BI. This takes us to the following part of this weblog put up, Integrating Energy BI with Azure DevOps.

Now that we perceive what Git and Azure DevOps are let’s see how we are able to combine Energy BI with Azure DevOps.

Integrating Energy BI with Azure DevOps has two totally different integrations. Cloud integration and native machine integration have the next necessities.


To observe together with this tutorial, you have to:

  • Within the cloud:
    • An Azure DevOps Service
    • A Energy BI account with one of many following licenses to allow Energy BI Workspace integration with Azure DevOps.:
      • Energy BI PPU (Premium Per Person)
      • Premium Capability
      • Embedded Capability (EM/A)
      • Material Capability
  • In your native machine:
    • The newest model of Energy BI Desktop (June 2023 or later)
    • Both Visible Studio or VS Code

As said earlier, this put up explains the Cloud integration partTherefore, we require to have an Azure DevOps Service and a Energy BI account with a Premium licencing plan to be able to combine Energy BI with Azure DevOps.

In the following couple of sections, we glance into extra particulars and undergo them collectively step-by-step.

Azure DevOps Service

Proper off the bat, everybody with a private Microsoft account (sure, a private account corresponding to Hotmail, MSN, Outlook, or Stay) or an organisational account can use Azure DevOps Service for free (as much as 5 customers). If you have already got an Azure DevOps Service, you possibly can entry it through https://aex.dev.azure.com/ to see the present Organizations after passing you credentials, which seems like the next picture:

Azure DevOps Existing Organizations
Azure DevOps Present Organizations

If that is the primary time you’re logging into Azure DevOps, then you have to to offer some extra particulars, as proven within the following picture:

First login to Azure DevOps
First login to Azure DevOps

In Azure DevOps, Group refers to a logical container that hosts a set of initiatives and sources. It serves as a top-level administrative unit that enables for managing and organising varied groups, repositories, pipelines, and different artefacts associated to software program improvement and supply.
As talked about earlier, everybody can create an Azure DevOps account and consequently create new Organizations. Nonetheless, this freedom might be restricted. Learn extra right here.

Group names are globally distinctive as their generated URL follows the “https://dev.azure.com/{your_organization_name}” sample. Due to this fact, it’s essential to plan in your organisation construction first.

If there aren’t any present organisations otherwise you shouldn’t have entry to any, you’ll see the next web page:
Azure DevOps Create New Organization
Azure DevOps Create New Group

Create New Group in Azure DevOps

Creating a brand new group is simple. Within the earlier picture, click on the Create new group button, then observe these steps:

  1. On the Get began with Azure DevOps web page, click on Proceed

Get started with Azure DevOps
Get began with Azure DevOps

  1. Kind a reputation in your Azure DevOps group
  2. Choose a internet hosting Area. Attempt to choose the identical area internet hosting your Energy BI (Material) tenant. Extra on this later
  3. Enter the validation problem
  4. Click on the Proceed button

Creating a new organization in Azure DevOps
Creating a brand new group in Azure DevOps

  1. Enter a brand new Undertaking title
  2. Click on the Create challenge button

Creating a new project in Azure DevOps
Creating a brand new challenge in Azure DevOps

To this point, we’ve got created a brand new Azure DevOps account, outlined an group, and created a challenge. We are going to be taught later on this weblog that Energy BI and Azure DevOps integration occurs on the Workspace stage. Due to this fact, utilizing the identical challenge title or much like the associated Workspace is smart. With that, let’s proceed.

  1. Click on Repos. Our repo is empty at this stage
  2. Click on the Initialize button to initialise the most important department to the repo

Initialize main branch in an Azure DevOps Repo
Initialize the principle department in an Azure DevOps Repo

We’re all set now. Subsequent, we have to combine a Energy BI Workspace with our Azure DevOps.

Join Energy BI Workspace to Azure DevOps

Now that we efficiently configured Azure DevOps, it’s simple to attach Energy BI Workspaces to it. As said earlier, we are able to solely allow this characteristic on Premium Workspaces (both PPU or a Premium capability).

If you have already got a Premium Workspace, then skip this part. In any other case, proceed studying.

Set Workspaces License

There are a number of methods to set a license to a Workspace. The next steps present a kind of strategies.

  1. In Energy BI Service, click on Workspaces
  2. Hover over the specified Workspace and click on the ellipsis button
  3. Click on Workspace settings
  4. Click on the Premium pane
  5. Choose the specified license
  6. Click on the Apply button

The next picture exhibits the above steps:

Assigning Power BI Workspace to Premium Licenses
Assigning Energy BI Workspace to Premium Licenses

Configure Git Integration in Energy BI

Now that we’ve got a Premium Workspace, let’s allow the Git Integration characteristic.

Observe these steps:

  1. From Energy BI Service, click on Workspaces
  2. Hover over the specified Workspace and click on the ellipsis button
  3. Click on Workspace settings
  4. Click on the Git integration pane
  5. Choose an Group
  6. Choose the specified Undertaking
  7. Choose a Git repository
  8. Choose a Department
  9. Enter the title of the Git folder you need to combine the supported Energy BI artefacts
  10. Click on the Join and sync button


Should you get the “Unable to connect with Git department. This workspace is in a distinct area. Go to the workspace admin settings to allow cross-region connections.” error at this level, then leap to the following part, the place I clarify methods to repair the problem.

Spoiler alert! It’s a must to be an admin to repair this, so in case you aren’t, please contact your directors, and they need to be capable of repair it for you. If you don’t get any errors, proceed studying.

  1. Energy BI asks in your affirmation if the folder doesn’t exist. Click on the Create and sync button

The next picture exhibits the previous steps:

Git integration on a Power BI Premium Workspace
Git Integration on a Energy BI Premium Workspace

After efficiently synchronising the supported Energy BI artefacts within the Workspace with the Git repository, it is best to see one thing like the next picture displaying the objects which are synced and never supported.

Power BI Premium Workspace after syncing with Git repo on Azure DevOps
Energy BI Premium Workspace after syncing with Git repo on Azure DevOps

As you see, this web page has a couple of modifications, corresponding to:

  1. A brand new Git standing added to the listing view within the Workspace
  2. A brand new Supply management pane added
  3. Git sync data on the standing bar displaying the Related department (the most important department in our instance), the Final synced time, and a hyperlink to the final Commit that the Workspace is in sync with.

Resolving the “Unable to connect with Git department. This workspace is in a distinct area. Go to the workspace admin settings to allow cross-region connections.” error

As identified within the earlier part, you could get the next error message when clicking the Join and sync button to combine your Workspace with Azure DevOps:

Fixing the Unable to connect to Git branch error in Power BI
Fixing the Unable to connect with Git department error in Energy BI

Should you face this error, it implies that your Energy BI tenant is in a distinct area than your Azure DevOps. That’s why I discussed earlier that it’s best to pick out the identical area as your Energy BI tenant when creating the Azure DevOps Group. To repair this challenge, you have to be a Material Administrator. Should you aren’t an admin, contact your administrator(s) to repair the problem. In any other case, observe these steps:

  1. Click on the Settings gear from the highest proper of your browser


Relying in your display screen decision, you may even see an ellipsis button on the highest proper of your browser. Click on the ellipsis button, then click on Settings.

  1. Click on Admin portal
  2. Scroll all the best way down from the Tenant settings tab to seek out the Git integration part. Increase the Customers can export objects to Git repositories in different geographical places (Preview) setting
  3. Click on to toggle button to Allow it. (In my instance, I enabled this characteristic to The complete group. It’s possible you’ll allow it just for Particular safety teams.)
  4. Click on the Apply button

The next picture exhibits these steps:
Enabling Users can export items to Git repositories in other geographical locations feature in the Fabric Admin Portal
Enabling Customers can export objects to Git repositories in different geographical places characteristic within the Material Admin Portal

Now that we’ve got allowed Git repositories to reside in a distinct geographical location than our Energy BI tenant, we are able to proceed the configuration from the place we left off.

This put up goals to cowl all elements of Integrating Energy BI Premium Workspaces with Git repositories on Azure DevOps. I’ll publish a separate put up on utilizing this integration to synchronise our codes between Energy BI Service within the cloud and the Energy BI Desktop challenge on our native machine.

Keep tuned!



Please enter your comment!
Please enter your name here