#Power BI PBIX File Installation

Tenant owners or application administrators can connect the reporting data from different modules of tyGraph to Power BI by installing Power BI template apps. These template apps can be found in Microsoft AppSource. For detailed instructions on connecting using Power BI template apps, visit the Connect Power BI Reports to Your Data section. This is the recommended and preferred way to experience tyGraph Power BI reports.

If, for any reason, you are unable to install template apps from AppSource and need to use the full PBIX files, you can download the PBIX files here. Follow the instructions provided to set up and connect your reports manually.

#Download PBIX Files

To connect your Power BI reports to your data using downloaded PBIX files, you can download the Power BI files in the Power BI Downloads section.

#Power BI Data Connection

To connect data to the reports by installing the following Power BI PBIX Files: tyGraph Teams, tyGraph OneDrive, tyGraph Pulse, tyGraph Viva Engage, and Microsoft Copilot, complete the following steps:

1. Sign in to Microsoft 365 and search for Power BI to open.

2. Click My workspace in the left navigation, click Upload, and click Browse to upload the Power BI PBIX file that you have downloaded.

3. You can switch from List view () to Lineage view () in the upper-right corner.

4. Sign in to tyGraph AOS Portal.

5. Navigate to Settings > Power BI template / Web part.

6. Select a tenant, copy the Database server, Database name, Username, and Password in the sections for Azure SQL Database, and then paste them into your desired location (such as Notepad).

7. Go back to My workspace, locate the Dataset card of a module, click the More options button, and click Settings to configure the following settings for datasets:

   • Parameters – Copy the database server and database name from the location where they are saved, and then paste them into the Server and Database fields. Then click Apply.

   • Data source credentials – Click Edit credentials and configure the following settings:

     1. Select Basic for authentication method.

     2. Copy the username and password from the location where they are saved, and then paste them into the User name and Password fields.

     3. Select the privacy level setting for this data source.

     4. Click Sign in.

8. Click Show in lineage view. Click the Refresh now button on the Dataset card to retrieve the latest data.

9. Click the Report card and then click Open report.

#Data Connection to tyGraph Calling and SharePoint

To connect data to reports using the tyGraph Calling or AvePoint tyGraph SharePoint Analytics PBIX Files, complete the following steps:

1. Sign in to Microsoft 365 and search for Power BI to open.

2. Click My workspace in the left navigation, click Upload, and click Browse to upload the Power BI PBIX Files that you have downloaded.

3. You can switch from List view () to Lineage view () in the upper-right corner.

4. Sign in to tyGraph.

5. Navigate to Settings > Power BI template / Web part.

6. Select a tenant, copy the Kusto cluster and Database name in the tyGraph Calling - Kusto or tyGraph SharePoint Analytics section, and then paste them into your desired location (such as Notepad).

7. Go back to My workspace, locate the Dataset card of tyGraph Calling or AvePoint tyGraph SharePoint Analytics, click the More options button, and click Settings to configure the following settings for datasets:

   • Parameters – Copy the Kusto cluster and database name from the location where they are saved, and then paste them into the ADX Cluster and Database Name fields. Then click Apply.

   • Data source credentials – Click Edit credentials, and then click Sign in.

8. Click Show in lineage view. Click the Refresh now button on the Dataset card to retrieve the latest data.

9. Click the Report card and then click Open report.

*Note: In US GCC and GCCH environments, connecting Power BI to tyGraph Calling and SharePoint databases is not currently supported.