The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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