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?
2 Comments
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:
Introducing Dataset Deployments with pbi-tools (Preview) | pbi-tools
Best regards.
Community Support Team_Caitlyn- rmsolfest
Advocate II
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.
