Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2026-08-07
Set Up Live Data Query in Power BI Desktop

Set Up Live Data Query in Power BI Desktop

At this time:
  • SSO-enabled tenants can't connect to LDQ from Power BI.
  • ISU authentication isn't supported with Power BI.
  1. Right-click the zip containing the .mez file and select
    Extract All
    .
    Extract the whole folder somewhere easy to find, such as your Desktop. Don't run the files from inside the zip preview. Always extract the contents first.
  2. Open config.txt from the extracted file in Notepad.
    1. Enter these values after the = signs (don’t use quotes):
      Property
      Value
      wd.authn.clientId
      Client ID created in the User-As-Self Authentication setup.
      wd.authn.clientSecret
      Client secret created in the User-As-Self Authentication setup.
      wd.authn.accessTokenEndpoint
      Token endpoint created in the User-As-Self Authentication setup.
      Example:
      https://{HOST}/ccx/oauth2/{TENANT}/token
      wd.authn.authorizationEndpoint
      Authorization endpoint created in the User-As-Self Authentication setup.
      Example:
      https://{HOST}/{TENANT}/authorize
    2. Save and close the file.
  3. In the extracted file, double-click Build-Connector.bat.
    A window opens, builds the connector, and installs it automatically. When it’s finished, close the window. The connector is installed to: Documents\Microsoft Power BI Desktop\Custom Connectors\WorkdayLDQ.mez.
    If Windows:
    • Shows a security error, run the .bat file anyway. This is expected behavior.
    • Can't copy the connector, close Power BI Desktop completely and run the .bat file again.
    1. In Power BI, select
      File
      Options
       .
    2. Select
      Settings
      Options
      Security
      Data Extensions
      .
    3. Select
      Allow any extension to load without validation or warning
      . This is necessary because this is an unsigned custom connector file.
    4. Click
      OK
      .
    5. Close Power BI Desktop completely and reopen it.
    1. In Power BI Desktop, select
      Get data from other sources
      .
    2. Search for Workday LDQ and click
      Connect
      .
    3. Sign in with your Workday account when prompted.
    4. Click
      Allow
       when prompted.
    5. The Navigator opens. Browse workday_core > public, select the tables you want, and click
      Load
      .