In this section, you will learn how to set up BI Pixie Dashboard to connect to the data that BI Pixie collects and allow you to analyze your Power BI reports through the lens of adoption, engagement, user satisfaction, business outcome, performance and security.
BI Pixie Dashboard is available on Microsoft AppSource as two different apps.
BI Pixie Dashboard (Starter) is the version that connects to the Microsoft Dataverse tables of your BI Pixie Starter Deployment (If you haven't installed it yet, follow this guide).
BI Pixie Dashboard is the version that connects to your Azure Storage account in the BI Pixie Azure Deployment (If you haven't installed it yet, follow this guide).
Note: Throughout the user guide, we may refer to BI Pixie Dashboard as "BI Pixie Analytics", "BI Pixie Power BI App", or "BI Pixie App". Consider these terms as synonyms. Also note that "BI Pixie Dashboard" is not a "dashboard" item in Power BI. It is a Power BI Template App that was certified and approved by Microsoft. You can learn more about Power BI Template Apps here.
After you install BI Pixie Dashboard as described in this article, you will have the following Power BI components in your Power BI service:
- A workspace that contains the following items:
- A report that can be customized in Editing view on Power BI service (Learn more here).
- A semantic model
- An app that is connected to the workspace and can be shared with your audience.
What is the difference between the two Power BI apps?
| Attributes | BI Pixie Dashboard (Starter Version) | BI Pixie Dashboard |
|---|---|---|
| Data source | BI Pixie Microsoft Dataverse tables in your Power Platform environment | BI Pixie's container in your Azure Data Lake Storage Account |
| Data source is deployed by | BI Pixie Starter Deployment on AppSource | BI Pixie Azure Deployment on Azure Marketplace |
| Unsupported features | Performance, Business Impact, RLS Auditing, Data Export Auditing, Custom Visuals Heatmap |
In the next section of this article, you learn how to install the Starter version of BI Pixie Dashboard and connect it to your Dataverse tables.
You can skip Starter section and move to the Azure section below, if you deployed or plan to deploy BI Pixie on Azure.
After you install this dashboard you can connect it to your Azure Storage or Dataverse tables where you have already deployed BI Pixie. However, if you wish to explore the dashboard using our sample data, you can install it without connecting it. Click one of the two buttons below to install the app in your Power BI service.
Starter Version Instructions
After you install BI Pixie Dashboard as a Power BI app from Microsoft AppSource, open the app and explore the different report pages with the sample data. After you completed the setup of BI Pixie Power Platform and completed the instrumentation and testing of your Power BI project files, it's time to connect the Power BI app with your data. Open the app and select Connect your data.
To connect the the starter version of BI Pixie Dashboard, you will need to enter the domain name of the Power Platform environment that you use. In a new browser tab, go to https://make.powerapps.com, and in the environments drop down select the environment you use to collect the pixie events (as was described here).
Click the gear icon at the top right side of Power Apps page and select Session details.
Find the Instance url line and copy the organization domain that is highlighted below. The organization domain should not include the https:// prefix or the last /. Copy only the part with the format org*.crm.dynamics.com
Go back to the browser tab where you previously clicked Connect your data in your Power BI app. In Connect to BI Pixie page, enter the organization domain name from the previous step in Organization Domain.
Enter the same email address for the trial or subscription of BI Pixie in Subscription Email. Finally, enter the license key you received from us in License Key (This is the same key you use in the configuration file of BI Pixie Instrumentation).
If you intend to track usage and engagement of anonymous users only, set the optional parameter Are Users Anonymous to TRUE. This parameter will ignore the user names and treat only IP addresses as the user key in the BI Pixie Dashboard. If you intend to analyze both anonymous and authenticated users, it is recommended to install this Power BI app twice. Use Are Users Anonymous to FALSE in the app that is dedicated to analyze the authenticated users, and use TRUE in the app that should analyze the anonymous users.
When you are done, enter Next.
In the next page, make sure that OAuth2 is selected as Authentication method, and that Organizational is selected as Privacy level setting for this data source. Then, click Sign in and continue.
In the next page, make sure that Anonymous is selected as Authentication method, and that Organizational is selected as Privacy level setting for this data source. Then, click Sign in and connect.
The semantic model of the app will now connect to BI Pixie Events dataverse table and import the usage and engagement data that is tracked by BI Pixie. The refresh can be long if you have large amount of records in BI Pixie Events.
Azure Version Instructions
After you install the Azure version of the app from Microsoft AppSource here, select BI Pixie Enterprise app and explore the different report pages with the sample data. After you completed the setup of the Azure components, it's time to connect the Power BI app with your data. Open the app and select Connect your data.
Enter the Data Lake URL. Make sure you enter the relevant components correctly. Don't use "/" at the end.
https://[bipixie storage name].dfs.core.windows.net/[container name]
Enter the same email address for the trial or subscription of BI Pixie in Subscription Email. Finally, enter the license key you received from us in License Key (This is the same key you use in the configuration file of BI Pixie Instrumentation).
If you intend to track usage and engagement of anonymous users only, set the optional parameter Are Users Anonymous to TRUE. This parameter will ignore the user names and treat only IP addresses as the user key in the BI Pixie Dashboard. If you intend to analyze both anonymous and authenticated users, it is recommended to install this app twice. Use Are Users Anonymous to FALSE in the app that is dedicated to analyze the authenticated users, and use TRUE in the app that should analyze the anonymous users.
When you are done, enter Next.
In the next page, make select the Authentication method based on the way you set up data access in the Data Lake Storage (e.g. Shared Access Signature – SAS). Select Organizational in Privacy level setting for this data source.
If you choose the Shared Access Signature as the Authentication method, make sure that you generate the SAS token at the bipixielake container level and that both the Read and List permissions are granted.
Then, click Sign in and continue.
In the second page, make sure that Anonymous is selected as Authentication method, and that Organizational is selected as Privacy level setting for this data source. Then, click Sign in and continue.
The second data source (raw.githubusercontent.com) allows BI Pixie Dashboard to import data from DataChant's repository here. With this data, BI Pixie knows all the available Custom Visuals on Microsoft AppSource and analyze engagement, performance and risks of custom visuals by their origin (Built-in visuals, Certified custom visuals, Uncertified custom visuals, Unlisted or Unknown).
In the third page, make sure that Anonymous is selected as Authentication method, and that Organizational is selected as Privacy level setting for this data source. Then, click Sign in and connect.
The third data source (prod-96.westus.logic.azure.com) is BI Pixie's backend that is used for license check.
The semantic model of the app will now connect to your Data Lake storage and import the usage and engagement data.