Tenants installations per app Dynamics 365 Business Central Usage Analytics

[powerbiqt]

Hi everyone!!

I need to retrieve data about tenants installations per each app. For that I use online version of Power BI with Dynamics 365 Business Central Usage Analytics template.
Question: On which page I can build the report that include: the tenant ID, environment name, app name, and installation counts? Any guidance on finding these details within the template would be greatly appreciated.

Thanks in advance!

[Shravan133]

To build a report in Power BI that includes the tenant ID, environment name, app name, and installation counts using the Dynamics 365 Business Central Usage Analytics template, you can follow these steps:

Step-by-Step Guide

1. Import the Template:

   • If you haven't already, import the Dynamics 365 Business Central Usage Analytics template into your Power BI workspace. This template can be found in the AppSource or provided by your Dynamics 365 admin.

2. Explore the Data Model:

   • Open the report in Power BI Desktop and switch to the Model view to explore the data tables available.
   • Identify the tables that contain information about tenant ID, environment name, app name, and installation counts.

3. Create a New Report Page:

   • Add a new report page to the template by clicking on the "+" icon at the bottom of the report.

4. Add the Required Fields:

   • In the Fields pane on the right, find the tables and fields relevant to tenant ID, environment name, app name, and installation counts. These fields are usually part of the usage or installation metrics tables.

   Example Field Names (may vary based on the template version):

   • Tenant ID: Could be found in a table named Tenants or similar.
   • Environment Name: Look for fields related to environment in the same or related tables.
   • App Name: Found in the Apps table or similar.
   • Installation Counts: Look for metrics or usage tables that track app installations.

5. Build the Report:

   • Drag and drop the fields into the report canvas to create a table or matrix visual.
   • Arrange the fields in the following order: Tenant ID, Environment Name, App Name, Installation Counts.

   Steps to create a table:

   • Go to the Visualizations pane and select the Table or Matrix visual.
   • Drag the fields from the Fields pane to the Values area in the Visualizations pane.
   • Adjust the formatting and layout as needed to ensure readability.

6. Apply Filters and Slicers (Optional):

   • Add slicers or filters to your report to make it more interactive. For example, you can add a slicer for the app name to filter installation counts by app.

Example

Here's a simple example of how to structure the table visual:

1. Visualizations Pane:

   • Select Table visual.

2. Fields Pane:

   • Drag Tenant ID to the Values field well.
   • Drag Environment Name to the Values field well.
   • Drag App Name to the Values field well.
   • Drag Installation Counts to the Values field well.

3. Configure and Format:

   • Ensure each field is correctly mapped and displayed.
   • Format the table to improve readability (e.g., adjust column widths, change fonts, apply conditional formatting if needed).

Finalizing and Publishing

• Once you are satisfied with your report, you can publish it to the Power BI service.
• Share the report with relevant stakeholders or embed it in your Dynamics 365 dashboards for broader access.

By following these steps, you should be able to create a comprehensive report that includes the tenant ID, environment name, app name, and installation counts using the Dynamics 365 Business Central Usage Analytics template in Power BI.