This topic describes how to connect to Data Lake Analytics (DLA) by using Power BI.

Prerequisites

  • Power BI is installed.
  • MySQL Connector is installed.

Procedure

  1. Start Power BI. On the Get Data page, choose Database > MySQL Database in the left-side navigation pane, and click Connect.
  2. On the MySQL Database page, configure the parameters.

    The following table describes the parameters.

    Parameter Description
    Server The endpoint of DLA. For more information about how to obtain the endpoint of DLA, see Connection overview.
    • If Power BI needs to access DLA over the Internet, set this parameter to the public endpoint of DLA.
    • If Power BI is installed on an Elastic Compute Service (ECS) instance that is deployed in the same region as DLA, set this parameter to the virtual private cloud (VPC) endpoint of DLA. This makes DLA access faster and more secure.
    Note In this topic, the port number of DLA is 10000. The default port number of the MySQL database, 3306, is not used. You can set this parameter based on your business requirements.
    Database The name of the database.
  3. Enter the username and password that are used to log on to DLA.
    Note You can obtain the username from the Account page in the DLA console. The password is the one that you specified when you create a DLA account. If you forget the password, reset it.
  4. After you configure the parameters, click OK.