From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

XMLA endpoint

XMLA endpoint - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

XMLA endpoint

“

- [Instructor] One of the benefits of using Power BI is that it enables us to connect large fact tables containing a lot of data to dimension tables that store the keys or labels for many of these records in both fact tables, for example. Much like multidimensional database predecessors, like SQL Server Analysis Services, Power BI connects these tables in the data model view for when the end user accesses them. The XMLA endpoint is a functionality built into the Power BI service that lets us connect other applications to our Power BI model. Connecting to the XMLA endpoint is very similar to connecting to a SQL Server Analysis Services database, for example. It does require a Power BI Premium account but we can also use the Premium per user as we'll see in this example. In Power BI Desktop, I already created a data model for the energy spot prices, along with the electricity generation for gas energy sources in the…

Contents