Microsoft Fabric Updates Blog

Using XMLA endpoints to change data sources in a Power BI dataset

The purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server Analysis Services maintain these settings in the data model.