Follow

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.

 

Pre-requisites

  • Login to app.powerbi.com
  • 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

mceclip0.png

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

mceclip2.png

mceclip3.png

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

mceclip4.png

  • 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 app.powerbi.com (i.e. email and password). Click save.

mceclip5.png

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.

mceclip7.png

Right click on the semantic instance and select Open instance.

mceclip9.png

 

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

mceclip10.png

 

Executing the endpoint in TimeXtender Desktop

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

mceclip11.png

Go to Workspace settings

 

mceclip12.png

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

mceclip13.png

  • 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

0 Comments

Please sign in to leave a comment.