Create Visual Experiences in Energy BI with Microsoft Price Administration Connector

The Microsoft Price Administration connector for Energy BI Desktop allows the creation of personalized visualizations and studies to boost understanding of Azure spending.

The Microsoft Price Administration connector at present helps clients.

• Direct Microsoft Buyer Agreements
• Enterprise Agreements (EA)
• Microsoft Accomplice Agreements

The Microsoft Price Administration connector makes use of OAuth 2.0 for authentication with Azure, producing legitimate tokens for a particular interval. Energy BI preserves these tokens for future sign-ins. To attach, use an Enterprise Administrator account for Enterprise Agreements or acceptable permissions at billing account or profile ranges.

Use Microsoft Price Administration to attach

To make use of Energy BI Desktop’s Microsoft Price Administration connector, take the next actions.

• Go to the House ribbon and select Get Knowledge.
• From the checklist of information classes, select Azure.
• Go together with Microsoft Price Administration.
  
• Use the Manually Enter Scope choice for Microsoft Buyer Agreements or the Enrollment Quantity choice for Enterprise Agreements (EA) within the ensuing dialog field.

Open an account utilizing the Microsoft Buyer Settlement

The procedures wanted to ascertain a connection to a Microsoft Buyer Settlement account are lined on this part.

Set up a reference to a billing account

You have to get hold of your billing account ID from the Azure portal with a view to hook up with a billing account.

• Go to Billing & Price Administration through the Azure portal.
• Select the billing profile that you really want.
• Select Properties from the sidebar beneath Settings within the menu.
• Copy the ID beneath the Billing profile.
  
• Choose Manually Enter Scope beneath Select Scope, and enter the connection string as displayed within the instance beneath, substituting the information copied from the earlier steps for {billingAccountId}. /suppliers/Microsoft.Billing/billingAccounts/{billingAccountId}
• As a substitute, select Enrollment Quantity beneath Select Scope and enter the Billing Account ID string that you simply copied from the sooner steps.
• After coming into the variety of months, click on OK.
  
• Alternatively, you possibly can outline a interval vary utilizing Begin interval and Finish Date values that equal lower than 31 days if you happen to want to obtain lower than a month’s price of information. Simply guarantee that the Variety of months is about to zero.
• Enter your Azure consumer account and password when prompted to log in. To efficiently entry the billing information, you have to have entry to the Billing account scope.

Set up a reference to an Enterprise Settlement account

You’ll be able to get hold of your enrollment ID through the Azure portal with a view to set up a reference to an Enterprise Settlement (EA) account:

• Go to Billing & Price Administration through the Azure portal.
• Select the account you need to be charged on.
• Copy the ID of the billing account from the Overview blade.
• To select the Enrollment Quantity, click on Select Scope.
• Paste the billing account ID that was copied within the earlier step into Scope Identifier.
• After coming into the variety of months, click on OK.
  
• Enter your Azure consumer account and password when prompted to log in. For Enterprise Agreements, you must make the most of an Enterprise Administrator account.
• Deciding on the containers subsequent to the names of the tables permits you to select a number of of them. The info can then be loaded by deciding on Load, or it may be additional reworked in Energy Question Editor by deciding on Remodel Knowledge.
  

Abstract

This text describes tips on how to make the most of the Microsoft Price Administration connector in Energy BI Desktop to generate visually interesting studies and visuals. Azure Databricks shall be lined within the upcoming put up.