Microsoft Power BI® XMLA¶
:::callout{theme="warning"} The following page discusses the Microsoft Power BI® XMLA connector for data integration. If you are searching for information on the Power BI® connector to access Foundry resources from the Power Query interface, review our analytics connectivity documentation. :::
The Microsoft Power BI® XMLA connector is a Palantir-provided driver for Microsoft Power BI® XMLA.
To create a new Microsoft Power BI® XMLA source, follow the standard setup flow for Palantir-provided drivers, then use the sections below for Microsoft Power BI® XMLA-specific configuration and networking. For the complete property reference, see the official Microsoft Power BI® XMLA driver documentation ↗.
Configuration¶
The properties below are mandatory or recommended.
| Property | Required? | Description | Default |
|---|---|---|---|
AuthScheme ↗ |
Recommended | The type of authentication to use when connecting to Microsoft Power BI XMLA. | AzureServicePrincipal |
AzureTenant ↗ |
Recommended | Identifies the Microsoft Power BI XMLA tenant being used to access data. Accepts either the tenant's domain name (for example, contoso.onmicrosoft.com ) or its directory (tenant) ID. | — |
InitiateOAuth ↗ |
Recommended | Specifies the process for obtaining or refreshing the OAuth access token, which maintains user access while an authenticated, authorized user is working. | GETANDREFRESH |
OAuthClientId ↗ |
Recommended | Specifies the client ID (also known as the consumer key) assigned to your custom OAuth application. This ID is required to identify the application to the OAuth authorization server during authentication. | — |
OAuthClientSecret ↗ |
Recommended | Specifies the client secret assigned to your custom OAuth application. This confidential value is used to authenticate the application to the OAuth authorization server. (Custom OAuth applications only.) | — |
PowerBIEnvironment ↗ |
Recommended | Specifies the PowerBI environment to use for API requests. | NONE |
Workspace ↗ |
Recommended | Specifies the Premium Power BI workspace(s) to connect to, using a comma-separated list of workspace names. | — |
Networking¶
The table below lists the domains that the source needs to be able to access in order to successfully run.
For each domain, add a corresponding egress policy. If the source is hosted on-premises and not directly reachable from Foundry, use an agent proxy egress policy instead; the agent host itself must also be able to reach the listed domains. See using an agent as a proxy for details.
| Domain | Required |
|---|---|
| api.powerbi.com | IF AzureEnvironment=GLOBAL(default) |
| *.pbidedicated.windows.net | IF AzureEnvironment=GLOBAL(default); The exact cluster used (added in the *) is determined by calling the api.powerbi.com |
| login.microsoftonline.com | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=GLOBAL (default) |
| login.chinacloudapi.cn | If AuthScheme=AzureAD (default), AzureServicePrincipal , AzureServicePrincipalCert AND AzureEnvironment=CHINA |
| login.microsoftonline.us | If AuthScheme=AzureAD (default), AzureServicePrincipal, AzureServicePrincipalCert AND AzureEnvironment=USGOVT,USGOVTHIGH USGOVTDOD |
| api.powerbigov.us | IF AzureEnvironment=USGOVT |
| api.high.powerbigov.us | IF AzureEnvironment=USGOVTHIGH |
| api.mil.powerbigov.us | IF AzureEnvironment=USGOVTDOD |
| *.pbidedicated.usgovcloudapi.net | IF AzureEnvironment=USGOVT,USGOVTHIGH,USGOVTDOD |
中文翻译¶
Microsoft Power BI® XMLA¶
:::callout{theme="warning"} 以下页面讨论的是用于数据集成的 Microsoft Power BI® XMLA 连接器。如果您正在寻找通过 Power Query 界面访问 Foundry 资源的 Power BI® 连接器相关信息，请查阅我们的分析连接文档。 :::
Microsoft Power BI® XMLA 连接器是 Palantir 为 Microsoft Power BI® XMLA 提供的驱动程序。
要创建新的 Microsoft Power BI® XMLA 数据源，请遵循 Palantir 提供驱动程序的标准设置流程，然后使用以下章节进行 Microsoft Power BI® XMLA 特定的配置和网络设置。有关完整的属性参考，请参阅官方 Microsoft Power BI® XMLA 驱动程序文档 ↗。
配置¶
以下属性为必填或推荐配置。
| 属性 | 是否必填 | 描述 | 默认值 |
|---|---|---|---|
AuthScheme ↗ |
推荐 | 连接到 Microsoft Power BI XMLA 时使用的身份验证类型。 | AzureServicePrincipal |
AzureTenant ↗ |
推荐 | 标识用于访问数据的 Microsoft Power BI XMLA 租户。接受租户的域名（例如 contoso.onmicrosoft.com）或其目录（租户）ID。 | — |
InitiateOAuth ↗ |
推荐 | 指定获取或刷新 OAuth 访问令牌的过程，该令牌在已认证授权用户工作时维持其访问权限。 | GETANDREFRESH |
OAuthClientId ↗ |
推荐 | 指定分配给您的自定义 OAuth 应用程序的客户端 ID（也称为消费者密钥）。此 ID 用于在身份验证过程中向 OAuth 授权服务器标识应用程序。 | — |
OAuthClientSecret ↗ |
推荐 | 指定分配给您的自定义 OAuth 应用程序的客户端密钥。此机密值用于向 OAuth 授权服务器验证应用程序的身份。（仅限自定义 OAuth 应用程序。） | — |
PowerBIEnvironment ↗ |
推荐 | 指定用于 API 请求的 PowerBI 环境。 | NONE |
Workspace ↗ |
推荐 | 指定要连接的 Premium Power BI 工作区，使用逗号分隔的工作区名称列表。 | — |
网络配置¶
下表列出了数据源为成功运行而需要能够访问的域名。
对于每个域名，请添加相应的出站策略。如果数据源部署在本地且无法从 Foundry 直接访问，请改用代理出站策略；代理主机本身也必须能够访问所列出的域名。详情请参阅使用代理作为代理服务器。
| 域名 | 所需条件 |
|---|---|
| api.powerbi.com | 如果 AzureEnvironment=GLOBAL（默认） |
| *.pbidedicated.windows.net | 如果 AzureEnvironment=GLOBAL（默认）；实际使用的集群（在 * 中添加）由调用 api.powerbi.com 确定 |
| login.microsoftonline.com | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=GLOBAL（默认） |
| login.chinacloudapi.cn | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=CHINA |
| login.microsoftonline.us | 如果 AuthScheme=AzureAD（默认）、AzureServicePrincipal、AzureServicePrincipalCert 且 AzureEnvironment=USGOVT、USGOVTHIGH、USGOVTDOD |
| api.powerbigov.us | 如果 AzureEnvironment=USGOVT |
| api.high.powerbigov.us | 如果 AzureEnvironment=USGOVTHIGH |
| api.mil.powerbigov.us | 如果 AzureEnvironment=USGOVTDOD |
| *.pbidedicated.usgovcloudapi.net | 如果 AzureEnvironment=USGOVT、USGOVTHIGH、USGOVTDOD |