Edit

Share via

LEAP (Beta) Power Query custom connector

  • Article

Note

The following connector article is provided by LEAP, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the LEAP website and use the support channels there.

Summary

Item Description
Release state Preview
Products supported Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication types supported Organizational account (LEAP Admin user account)

Prerequisites

Before you can sign in to LEAP, you must have a LEAP Admin user account.

Capabilities supported

  • Import

Connect to LEAP data from Power Query Desktop

To connect to LEAP data from Power Query Desktop, take the following steps:

  1. Select Get Data from the Home ribbon in Power BI Desktop. Select Online Services from the categories on the left, select LEAP (Beta), and then select Connect.

    Screenshot of Online Services category and the LEAP connector highlighted.

  2. If you're getting data through the LEAP connector for the first time, a preview connector notice is displayed. Select Don't warn me again with this connector if you don't want this message to be displayed again, and then select Continue.

  3. To sign in to your LEAP Admin user account, select Sign in.

    Screenshot of the LEAP account highlighted, and showing the sign in button.

  4. In the LEAP window that appears, provide your credentials to sign in to your LEAP Admin user account.

    Screenshot of the sign in screen for LEAP.

  5. Select Sign in.

  6. Once you've successfully signed in, select Connect.

    Screenshot of the user signed in and ready to connect.

  7. In Navigator, select the information you want, then either select Load to load the data or Transform Data to continue transforming the data in the Power Query editor.

    Power Query Navigator showing LEAP data.

Load data from LEAP in Power Query Online

To connect to LEAP from Power Query Online, take the following steps:

  1. Select the LEAP (Beta) option in the connector selection.

  2. In the dialog that appears:

    1. Connection: Create new connection.
    2. Data Gateway: (none).
    3. Authentication kind: (Organizational account).

  3. If you're connecting using LEAP for the first time or have recently changed your password, you must sign in to your LEAP Admin user account.

  4. Once you've signed in, the Navigator appears.

  5. In Navigator, select the information you want, then select Transform Data to transform the data in the Power Query editor.