Getting started

This guide will teach you how to authenticate with Foundry via Power BI®, select a dataset, and get started building your first report.

Select Foundry as your data source in Power BI®

  • From Power BI®, click on "Get data" in the ribbon and select "More".
  • Search for "Palantir Foundry" in the data sources list, or select it under Online Services.
  • If you encounter an error at this point, ensure you've completed the installation instructions.

pbi-get-data

Configure your connection settings

You'll now be prompted for some details about your Foundry connection:

  • Base URL: Enter your Foundry connection URL under "Base URL". Your Foundry connection URL is the link you normally use to access Foundry. You should be able to copy-paste this path by right clicking and copying the link address: Base URL. (Note if you load this URL in your browser it may redirect to another page. If this happens, simply delete anything after ".com" in the address, and you will have the base URL again.)
  • (Optional) Dataset RID & Branch: If you already know the dataset RID or branch of the dataset you wish to access, you can enter this information here. (See Guides: Identifying a dataset's RID or filepath in Foundry.) Otherwise, leave these fields blank. There will be a dataset browser in a subsequent step where you can select your data.
  • Data Connectivity Mode: Select whether you would like to use the "Import" or "DirectQuery" mode.

Click "OK" and proceed to the next step.

connection-settings

Authenticate with Foundry

There are two options for authenticating with Foundry - either "Foundry OAuth" or "Foundry Token". OAuth is the simplest, recommended authentication method in most circumstances.

You can select whether to use OAuth or Token authentication on the left-hand side of the Power BI® authentication dialog. Instructions for using both authentication options are described below.

OAuth is the recommended method for authorizing Power BI® to connect to Foundry. If using OAuth authentication, you can simply click on "Sign in" from the Power BI® OAuth dialog. This will then open a new window with your Foundry login screen.

If this is your first time using Power BI® with Foundry, you will be prompted to approve Power BI®'s access to your Foundry account. Click to "allow" Power BI®'s request for access, and then sign in to Foundry as normal.

oauth

If you receive an error page logging in via OAuth, it is likely your organization has not yet enabled the OAuth login capability for Power BI®. In this case, contact your Foundry administrator to enable Power BI® as a third-party application. You can also use the alternative token-based authentication option described below in the meantime.

Foundry Token Authentication

If using token-based authentication, follow the instructions on Generating a Token to generate a private authentication token inside Foundry. Once you have the token, you can paste it into the Power BI® prompt.

Your credentials should now be saved in Power BI® and will continue to work as long as they are valid. You won't be prompted for a token again until your token validity has expired. At this point you can follow the above instructions again to generate a new token.

Connect to Foundry and select your dataset

  • Use the navigator on the left hand side to select the dataset(s) you'll need for your report.
  • Once you've made your selection, choose either "Load" or "Transform Data" and proceed with building your report as usual.

dataset

Power BI® and the Power BI® logo are trademarks of the Microsoft group of companies.