# Add Your Own Prices

{% hint style="info" %}
You can only add one price per SKU!\
If your organization have bought licenses on different terms (Monthly, Annual) with different prices, try our [Average SKU price calculator Excel spreadsheet](https://docs.bsure.io/v1/user-guides/microsoft-licenses/add-your-own-prices/average-sku-price-calculator) to find the average price on your different SKUs.
{% endhint %}

### 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.

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FTT6UpDENoIiEAvPdZciJ%2Fimage.png?alt=media&#x26;token=499cb31c-2f2e-4fbb-b2ea-b81b05bd5551" alt=""><figcaption></figcaption></figure>

### Set Prices in your Storage Account

Go to the [Azure portal](https://portal.azure.com), and locate the *Storage Account* you set up as one of the [prerequisites](https://docs.bsure.io/v1/installation/prerequisites#azure-managed-application) when you installed the Azure Managed Application. It is the *Storage Account* you used when you connected the Power Bi App to your data.

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

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/iUyWT5gSIu1vSUTbvYHp/image.png" alt=""><figcaption><p>Locate your Storage Account and select it.</p></figcaption></figure>

Select **Storage Browser** in the menu.

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/VNb48p4U6LuilGfxJjTg/image.png" alt=""><figcaption></figcaption></figure>

Select **Tables**.

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/j3g0OWqiqM0XcUTIfDjc/image.png" alt=""><figcaption></figcaption></figure>

Select **TblCustomerSkuPrices**.

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/uEa2Ty6CAafhjw5jKD6u/image.png" alt=""><figcaption></figcaption></figure>

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

{% hint style="warning" %}
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.
{% endhint %}

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/4jNiEyv5WvyGAWQwWihL/image.png" alt=""><figcaption></figcaption></figure>

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

{% hint style="info" %}
You can choose to add prices in your own currency.

Use . (dot) as decimal symbol.
{% endhint %}

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/5fqpPNEeoFThioGIPrgw/image.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/4WQ43TNecm74LKFUA7nO/image.png" alt=""><figcaption></figcaption></figure>

### Select Your Own Prices in the Power Bi App

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

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/j5PX9THA9S0XAfQ95E4m/image.png" alt=""><figcaption></figcaption></figure>

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**.

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/IJLPc7nQmM9k0fKvp3vS/image.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/8ZA9wzEc66a3iRTBh11w/blobs/dJ7fed0FpjHDp5mcw8fz/image.png" alt=""><figcaption></figcaption></figure>