Power BI Quick Start Reports

If you are using Tricentis Analytics with Microsoft Power BI, a file of quick start reports is available for your use. When you initially download the Power BI Quick Start Reports file, the file includes out-of-the-box reports that are preloaded with sample data, allowing you to explore the reports and determine how the data can be useful for your business. You can also add or modify reports to suit your business needs. Once you connect the file with your database, the reports load with your data.

Tricentis Analytics can also be used with different business intelligence (BI) tools. For more information about BI tool integration, refer to BI Tool Integration.

Click here to download the Power BI Quick Start Reports file.

For more information about downloading and using Power BI, refer to the Microsoft Power BI site.

Connect the Power BI Quick Start Reports file to the Tricentis Analytics database

The Power BI Quick Start Reports file connects to the Tricentis Analytics database using an OData URL. Connecting to the database is only required upon initial set up. This procedure provides steps for connecting the Tricentis Analytics database to the Power BI Quick Start Reports file.

  1. Obtain your Data Source URL from the Tricentis Analytics API Developer Portal. For information on logging in to the API Developer Portal, refer to Tricentis Analytics API Developer Portal.

  2. Open the Power BI Quick Start Reports file in Microsoft Power BI.

  3. When you initially open the Power BI Quick Start Reports file, the following OData feed module may appear. Click Cancel.

  4. If the following Refresh module appears, click Close.

  5. On the Power BI ribbon, click File. Then click Options and settings.

  6. On the Options and settings screen, click Data source settings.

    The Data source settings module appears.

  7. On the Data source settings module, click Change Source.

    The OData feed module appears.

  8. In the URL field on the OData feed module, enter the URL you obtained from the Data Source row in the API Endpoints section of the Tricentis Analytics API Developer Portal. Then click OK to return to the Data source settings module.

  9. If you need to update your credentials, click Edit Permissions on the Data source settings module.

    If you do not need to update your credentials, proceed to step 9.

    The Edit Permissions module appears.

  10. On the Edit Permissions module, click Edit. Then update your credentials.

  11. Click OK to close the Edit Permissions module.

  12. Click Close to close the Data source settings module.

  13. In the Power BI Quick Start Reports file, a banner now appears, indicating that there are pending changes that have not been applied. Click Apply changes to apply the new data source changes.

    The Power BI Quick Start Reports file refreshes with the data from your Tricentis Analytics database.