Power BI Integration

Power BI Integration

How to get LRS data into Power BI

You can easily connect the Veracity LRS to Microsoft Power BI. In the LRS, save a Statement Viewer report and create an API key. In Power BI, configure and activate a data download channel with this information.
  1. In the LRS, in the left menu, select Management > All Management Tools.

  2. In the Manage page for your store, scroll down to the Security section, and click the API Keys menu option.


  3. Click the Create New API Key button.


  4. In the Create API Key page, enter a name for your key, then click the Create button.


  5. On the Manage API Keys page, in the record for the new key, click the “eye” icon to show the API Key Value, then copy the value.


  6. Switch to the Power BI app, open the Get Data dialog, select Other > Web.


  7. In the From Web dialog box, select Advanced. Then, in the HTTP request header parameters section, select the header x-veracity-api-key, and paste the API key.


  8. Switch back to the LRS, and in the Configure Statement Viewer panel, find your saved report and click the Integration button to the right. From the pop-up dialog box, copy the URL.


  9. Switch back to Power BI, and in the URL parts section of the From Web dialog box, paste the URL. 


  10. Click the OK button. Then click Load. 
Now, Power BI will download your data. 



    • Related Articles

    • LMS Integration

      The Veracity Learning offers seamless integration with your LMS to allow instructors and students to access the services of the LRS without leaving their LMS environment. This is accomplished via LTI (Learning Tools Interoperability), a standard from ...

    • SQL Integration

      Only the Enterprise version of the LRS supports SQL Integration. The Veracity LRS can send xAPI statements to a SQL database in real time. The LRS opens a connection to your SQL server, and synchs statements every 300 milliseconds. The LRS won’t ...

    • Elasticsearch Integration

      Overview The LRS can accelerate its dashboard and statement viewer by leveraging Elasticsearch in addition to MongoDB. When configured with the optional Elasticsearch connection, the LRS will synchronize xAPI statements in real time between these two ...

    • Single Sign On (SSO) Integration

      Veracity can integrate with your single sign on provider using OpenID Connect or Security Assertion Markup Language (SAML). This integration allows your enterprise users to log into the LRS user interface without providing a password. Integrating a ...

    • Tableau Integration

      Veracity LRS supports Tableau via a Web Data Connector. This connector allows you to import your saved statement reports into Tableau for analysis. This tool can only pull saved statement viewer reports. If you have none, first create any report in ...