Power BI XMLA Endpoint

This article describes how to add a Power BI XMLA Endpoint in the portal, and deploy and execute the semantic model from TimeXtender Desktop.



  • Login to
  • Select the workspace where the XMLA endpoint will be deployed to
  • Go to Workspace Settings, select Premium per user for the License mode (this requires a Premium per user license), and copy the workspace connection. mceclip1.png
  • In order for an Azure application to be used as service principal for deployment and execution of the Power BI XMLA Endpoint, an app registration is required with the following read API for Power BI. Also, ensure to add the Azure app as admin for the Power BI workspace. mceclip0.pngmceclip2.png
  • Also, if using an Azure app as service principal, ensure that the "Allow service pricipals to use Power BI APIs" setting is enabled in the Power BI Admin portal. Also ensure that the app is added to the specific security group that has been defined in the Tenant Developer Settings . Alternatively, set the "apply to" setting to allow "the entire organization" blobid0.pngmceclip3.png


  • Go to the admin portal and ensure that the XMLA endpoint is set to "Read Write". 



Adding an Power BI XMLA Endpoint in the portal

  • Go to the TimeXtender portal and add a Semantic instance, and add a Power BI Premium endpoint


  • Provide a name for the endpoint, and for the server paste the Workspace Connection from Power BI that was copied earlier. Enter a name that for the Power BI Dataset, and the credentials used to log onto (i.e. email and password). Click save.


If using an app registration for the deployment and execution of the Power BI XMLA Endpoint, then enter app:<appId>@<tenantId> in the username field and the app client secret in the password field, as documented by Microsoft.


Deploying the endpoint in TimeXtender Desktop

  • Open TimeXtender Desktop, and sign in. Refresh the instances in order to get the newly created semantic instance and endpoint.


Right click on the semantic instance and select Open instance.



  • Drag the tables from the Data Warehouse into the Semantic instance. Right click on the instance and select Deploy.



Executing the endpoint in TimeXtender Desktop

  • Login to and go to the workspace. The dataset should now be available.


Go to Workspace settings



  • Under data source credentials, select Edit credentials and enter the credentials for the Data Warehouse.


  • If you are unable to successfully edit the data source credentials, try to take over the dataset settings first and then edit the credentialsmceclip3.png
  • Go back into TimeXtender Desktop, right click on the Semantic Instance and select Execute.


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.