Edit

Palantir Foundry

  • Article

Note

The following connector article is provided by Palantir, 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 Palantir website and use the support channels there.

Summary

Item Description
Release State General Availability
Products Power BI (Semantic models)
Power BI (Dataflows)
Fabric (Dataflow Gen2)
Authentication Types Supported Organizational Account (Power BI Desktop)
Personal Access Token

Prerequisites

This connector works with any active Palantir Foundry environment. Ensure you've completed the following setup steps before using the connector:

  1. Download and install the Foundry datasets ODBC driver.
  2. If using OAuth authentication, ensure your Foundry administrators have enabled the "Power BI®" third-party application in Control Panel. See the Foundry third-party apps documentation for more details.

Capabilities supported

  • Import
  • DirectQuery (Power BI semantic models)

Connect to Palantir Foundry from Power Query Desktop

To connect to Palantir Foundry from Power Query Desktop, take the following steps:

  1. In the Get Data experience, select the Palantir Foundry option in the connector selection.

  2. In Connection Settings, provide the Base URL of your Foundry environment. For example, https://<subdomain>.palantirfoundry.com/. Optionally, provide a Dataset RID and Branch.

    Screenshot of the Palantir Foundry connection settings in Power Query Desktop.

  3. Select either the Import or DirectQuery data connectivity mode.

  4. Select OK.

  5. If you're connecting to Foundry for the first time, select either the Foundry OAuth (recommended) or Foundry Token authentication type. After signing in (Foundry OAuth) or entering a token (Foundry Token), select Connect.

    Screenshot of the Palantir Foundry authentication.

    For more details on these authentication options, go to Foundry's Power BI: Authenticate with Foundry documentation.

  6. In Navigator, select the data set(s) you want, then select either Load to load the data or Transform Data to continue transforming the data in the Power Query editor.

    Screenshot of the Power Query Desktop Navigator showing the selected data set.

Connect to Palantir Foundry from Power Query Online

Note

Before you begin, ensure you have access to an on-premises gateway with an existing connection to Foundry.

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

  1. Select the Palantir Foundry option in the connector selection.

  2. In Connection Settings, provide the Base URL that matches a connection already configured on your on-premises data gateway. For example, https://<subdomain>.palantirfoundry.com/. Optionally, provide a Dataset RID and Branch.

    Screenshot of the Palantir Foundry connection settings in Power Query Online.

    Ensure that the Connection dropdown shows the name of your on-premises gateway.

  3. Select Next to continue.

  4. In Navigator, select the data you require, and then select Transform data.

    Screenshot of the Power Query Online Navigator showing the selected data set.

Troubleshooting

If you encounter issues connecting to Foundry, refer to the following resources in Palantir Foundry's documentation for troubleshooting steps: