Link Search Menu Expand Document
EduFrame PowerBI Connector

Legacy Installation

This is an outdated explanation on how to install and use the custom connector for importing EduFrame data into Power BI on an educator level. In case you still use the beta version, this guide should be followed. If not, please follow the most recent install instructions.

Install requirements

In order to using the custom connector, you need the following:

  • A windows operating system
  • The custom connector
  • Power BI Desktop
  • A personal API-key generated in EduFrame

Installation steps

  1. Install Power BI Desktop using the link provided above.
  2. Navigate to: C:\Users\<your username>\Documents\Power BI Desktop\Custom Connectors. If this folder does not exist (either Power BI Desktop or Custom Connectors), just manually create the folder.
  3. Paste EduFrame_Connector.mez in this folder.
  4. (optional) Restart the Power BI Desktop client if you had the application open.

Usage

After following the installation steps, you can find the connector in the list of connectors in Power BI Desktop. First, we need to change the security settings to allow for third-party connectors like the one for EduFrame.

  1. Open Power BI Desktop.
  2. Press File in the top left corner of the application window.
  3. Press Options and settings and immediately after press Options.

  4. Go to the Security tab and select (Not Recommended) Allow any extension to load without validation or warning.

    Security tab

  5. Press Ok.

Now we are ready to use the connector.

  1. Click Get data.

  2. Find the EduFrame Connector in the list.

    EduFrame Connector

    and press Connect.

  3. When you press connect, you will be promped with a API Url field. Enter your EduFrame url. (Example: https://drieam.com/) As of now, there is no error checking here, so make sure you enter the url exactly correct (Including HTTPS:// and a / at the end). Press Ok.

  4. Get your API-key ready, as you have to provide it in the next screen.

    Authentication

    Enter the API-Key in the Account key field. The second field is supposed to show the url you entered before. Press Connect.

  5. You will now be prompted with the Navigator.

    Navigator

    This window shows all the tables that you can import. Select the desired tables and press Load.

You are now ready to use the imported data to build reports in Power BI.