Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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