# Groups

You can specify which groups You want to include in the report, set a cost per member of each group and give the groups a friendly name.

**Key benefits with report**

* Cost Allocation
* See members of groups with administrative privileges

Report will be empty until you follow instructions to [Configure which groups to show in the report](#configure-which-groups-to-show-in-the-report)

The report will show You all your specified groups in the Focus table with how many users and the total cost per group. The report itself has the same setup as the other reports with a focus table, a breakdown table and a user details table

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FeSGu3rZ148Aq2XStCVkm%2Fimage.png?alt=media&#x26;token=af023299-9396-4373-b8d2-83a1e32864c6" alt=""><figcaption></figcaption></figure>

### How to configure which groups to show in the report

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://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FfZlulK7kQCyaShIINWuZ%2Fimage.png?alt=media&#x26;token=35424c2e-fde4-47ef-8695-5118e3e641da" alt=""><figcaption></figcaption></figure>

Select **Storage Browser** in the menu.

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FufZ8h2IEL5BH6rw6ohrd%2Fimage.png?alt=media&#x26;token=9d5e39f6-2595-4c6b-b8a5-e861f21fbac7" alt=""><figcaption></figcaption></figure>

Select **Tables**.

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FRjELgPHT4vUeLDfPM1Xj%2Fimage.png?alt=media&#x26;token=906eceea-91a6-4bd5-ab18-f957fef70dc2" alt=""><figcaption></figcaption></figure>

Select **TblConfigGroupMembership**.

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FqivLn0K2KJbNv2vBy8SK%2Fimage.png?alt=media&#x26;token=f814bc26-baf9-43ed-9d0d-3ba2468f2914" alt=""><figcaption></figcaption></figure>

You need to enter values that will identify the correct group and set correct properties.

Open a new tab in your preferred browser and go to [Entra ID portal](https://entra.microsoft.com/#view/Microsoft_AAD_IAM/TenantOverview.ReactView)

Copy and save your tenant ID for later usage

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FDkb3wpmZ0OdJyrSLVXrW%2Fimage.png?alt=media&#x26;token=11cd6794-d0da-4f0c-b9c5-e07337d66a1a" alt=""><figcaption></figcaption></figure>

Navigate to [Entra ID Groups](https://entra.microsoft.com/#view/Microsoft_AAD_IAM/GroupsManagementMenuBlade/~/AllGroups/menuId/AllGroups) and search for the groups you would like to add to the report.

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FadJxyYH3g8aLElpDQ2ba%2Fimage.png?alt=media&#x26;token=c50e7767-a3fa-4f49-b28c-1a678845db2f" alt=""><figcaption></figcaption></figure>

Copy Object Id for the group.

Go back to the browser tab where you have the Storage account and click Add entity

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FnjPELylEqGwup9Cbq0xj%2Fimage.png?alt=media&#x26;token=99297416-4773-4547-b551-226925de0447" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1625452539-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F8ZA9wzEc66a3iRTBh11w%2Fuploads%2FopeWyppGzVZ6icYmNMOk%2Fimage.png?alt=media&#x26;token=17d81d95-72a4-4a7e-9fd7-12171dffbd0f" alt=""><figcaption><p>PartitionKey = Object ID of group <br>RowKey = Tenant ID</p></figcaption></figure>

Bsure Insights backend will now collect data needed at next run cycle and You will see the result after report refresh next day. Remember to [schedule refresh of Your report after 6 am](https://docs.bsure.io/v1/installation/installation-instructions#step-5-configure-power-bi-app-data-refresh) to get the latest information available in your report.

***NB: Make sure you enter a value in field CostPerMember (could be 0) to see which users are member of the group in the Power BI report.***