Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Setup XMLA data source in Report Builder?

I am no longer able to configure an XMLA data source to a Power BI semantic model in Power BI Report Builder 

AND

the PBI Pipeline Deployment rule in PBI Service to update the XMLA data source value throws an error.

 

Troubleshooting intermittent connection errors using GUI to link to PBI semantic model per Microsoft -> 
"For paginated reports running longer than 10 minutes, we recommend using the XMLA endpoint to connect to the Power BI semantic model."
Troubleshoot paginated report execution issues - Power BI | Microsoft Learn

 

However, I cannot find a way to configure an XMLA endpoint (semantic model in a premium workspace) in PBI Report Builder. 

 

How can one configure an XMLA endpoint in PBI Report Builder?

AND

Are XMLA data sources still supported in the PBI Service's Deployment Pipelines?

Status: Delivered

hi @rmsolfest ,

 

To configure an XMLA endpoint in Power BI Report Builder, follow these steps:

1.Enable XMLA Endpoint: Ensure that the XMLA endpoint is enabled in your Power BI Premium capacity. You can do this by navigating to the Power BI Admin portal, selecting “Capacity settings,” and enabling the XMLA endpoint under the specific capacity settings.
2.Connect to the XMLA Endpoint: Open Power BI Report Builder and create a new data source. Choose “Microsoft Analysis Services” as the connection type and enter the XMLA endpoint URL. This URL typically looks like .powerbi://api.powerbi.com/v1.0/myorg/{workspaceName}
3.Set Credentials: Provide the necessary credentials to access the XMLA endpoint. This usually involves using your Power BI account credentials.
 Once connected, you can create datasets by writing DAX queries or using the query designer to fetch data from your Power BI datasets.
Regarding the support for XMLA data sources in Power BI Service’s Deployment Pipelines, XMLA data sources are still supported. You can use XMLA endpoints to manage and deploy datasets within Deployment Pipelines.

 

For more you may refer to:

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...

Using XMLA endpoints to change data sources in a Power BI dataset | Microsoft Power BI Blog | Micros...

Introducing Dataset Deployments with pbi-tools (Preview) | pbi-tools

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

hi @rmsolfest ,

 

To configure an XMLA endpoint in Power BI Report Builder, follow these steps:

1.Enable XMLA Endpoint: Ensure that the XMLA endpoint is enabled in your Power BI Premium capacity. You can do this by navigating to the Power BI Admin portal, selecting “Capacity settings,” and enabling the XMLA endpoint under the specific capacity settings.
2.Connect to the XMLA Endpoint: Open Power BI Report Builder and create a new data source. Choose “Microsoft Analysis Services” as the connection type and enter the XMLA endpoint URL. This URL typically looks like .powerbi://api.powerbi.com/v1.0/myorg/{workspaceName}
3.Set Credentials: Provide the necessary credentials to access the XMLA endpoint. This usually involves using your Power BI account credentials.
 Once connected, you can create datasets by writing DAX queries or using the query designer to fetch data from your Power BI datasets.
Regarding the support for XMLA data sources in Power BI Service’s Deployment Pipelines, XMLA data sources are still supported. You can use XMLA endpoints to manage and deploy datasets within Deployment Pipelines.

 

For more you may refer to:

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft...

Using XMLA endpoints to change data sources in a Power BI dataset | Microsoft Power BI Blog | Micros...

Introducing Dataset Deployments with pbi-tools (Preview) | pbi-tools

 

Best regards.
Community Support Team_Caitlyn

rmsolfest
Advocate I

Thank You - This WORKED!

 

Previously I had connected using a 'Power BI Dataset' from the Conection Type dropdown menu, which is no longer available in the updated version of Report Builder.  This also stopped working as a Deployment Pipeline Rule when I tried to publish a minor update thru the pipeline.

With the configuration change listed the above post, the report runs appropriately and I have also confirmed that I can again use a PBI Deployment Pipeline rule for the 'Azure Analysis Services' connections like before. 

Noteworthy, these AAS XMLA connections do not auto-bind with the associated semantic models in the parallel pipeline's workspaces.  Thus one still has to use a Deployment Rule to re-bind as the paginated report is promoted to the higher environments.