Bsure Documentation
back to bsure.io
  • Welcome
  • Installation
    • Overview
    • Prerequisites
    • Installation Instructions
  • Technical Description
    • Design Principles
    • Azure Managed Application
    • Permissions Required
    • Security​
      • Public IP and Storage Account Key considerations
    • Technical Architecture
    • Dataflow and visibility
  • User guides
    • Overview
    • Main Dashboard
    • Users
      • Dashboard
      • Members
      • Guests
      • Data Quality
      • Properties
      • Sign-in Map
      • Sign-in Locations
      • Drilldown
    • Microsoft Licenses
      • Cost Dashboard
      • Licenses Overview
      • Subscription Overview
      • Inactive and Disabled Users
      • Overlapping licenses
      • Cost Allocation
      • Drilldown
      • Price Settings
      • Add Your Own Prices
        • Average SKU Price Calculator
    • Applications
      • Usage
      • Cost
      • Sign-in Locations
        • Successful sign-ins from blocked countries?
    • Groups
    • Security
      • Dashboard
      • Authentiation Methods
      • Entra ID Roles
      • Service Principals
    • Devices
      • Windows Dashboard
      • Windows Inactive Devices
      • Windows OS
      • Windows Management
      • Devices per Person
      • Drilldown
    • Share the Power BI App
      • Share App only
      • Give Access to the Power BI Workspace
      • Share the Storage Account Access Key
      • Share with External Users
    • Update Power BI App
    • Glossary
  • Pricing & Billing
    • Pricing
    • Billing
  • Support
    • Support
    • Frequently Asked Questions
    • Troubleshooting
    • Release Notes
    • New features
      • User purpose property
  • Partners
    • Partner sell an offering including the app to the customers
    • Customer have a strict data protection regime
    • Partner uses the app without customer knowledge
    • General considerations
  • Policies
    • Privacy Policy
    • Terms & Conditions
  • RECOMMENDED ACTIONS
    • Recommended actions
      • Review Entra ID role assignments and create a strategy to offer such roles
      • Review and remove all inactive or unwanted accounts
        • Bulk deletion of users in Entra ID
      • Protect all users with MFA
      • Review and clean up applications with excessive permissions
Powered by GitBook
On this page
  • Power BI App Settings
  • Set Prices in your Storage Account
  • Select Your Own Prices in the Power Bi App
  1. User guides
  2. Microsoft Licenses

Add Your Own Prices

By default the prices in our Power Bi App are standard Microsoft list prices in USD. These prices will not be accurate for many organizations. This page will show you how you can add your own prices!

PreviousPrice SettingsNextAverage SKU Price Calculator

Last updated 1 year ago

You can only add one price per SKU! If your organization have bought licenses on different terms (Monthly, Annual) with different prices, try our to find the average price on your different SKUs.

Power BI App Settings

Go to Settings in the Power Bi App. This is where you can toggle between List Price and Your Price. In the example screenshot below own prices are set, but if customer price is -1 it means no prices have been set as own prices are default -1.

Set Prices in your Storage Account

An easy way to locate it, is to use the top search bar in the Azure portal:

Select Storage Browser in the menu.

Select Tables.

Select TblCustomerSkuPrices.

The table contains all the licenses available in your Azure AD. Both paid and free.

You need to update prices in the column customUnitPrice for all rows in the table! - Add your own prices for paid licenses. - Set free licenses to 0.

Double-click each row to edit. Add your own price, and Update.

You can choose to add prices in your own currency.

Use . (dot) as decimal symbol.

All prices updated! In this example prices are added in NOK (Norwegian Krone).

Select Your Own Prices in the Power Bi App

Go to your Power Bi Workspace, and select to refresh the Bsure Insights dataset.

When refresh is done, go to the Power Bi report, and open the Settings page.

Verify that you can see the prices you added to the customUnitPrice column in the TblCustomerSkuPrices table.

Select Your Price and your currency.

Enjoy the Bsure Insights report showing your own prices in your own currency!

Go to the , and locate the Storage Account you set up as one of the when you installed the Azure Managed Application. It is the Storage Account you used when you connected the Power Bi App to your data.

Average SKU price calculator Excel spreadsheet
Azure portal
prerequisites
Locate your Storage Account and select it.