Power BI — XMLA endpoint
An XMLA endpoint is a protocol for communication between client applications and an engine managing Power BI workspaces and datasets. Power BI is based on a tabular engine. So, for people who are experienced with the Analysis Services Tabular model development; the XMLA endpoint is nothing new. But for Power BI developers is a game changer.
This way you can connect to datasets or workspaces. A Read permission is set by default. If you want to turn a Read/Write permission on you can do it through the admin portal.
You can use a tabular model from many applications like Excel, Tabular Editor, SQL Server Management Studio, Visual Studio, DAX Studio. You need to enter your workspace address and credentials.
Connecting to SSMS:
You can use it with Excel:
…or query the model from DAX Studio:
For now, I showed how to read a model. There is an example how you can write to the XMLA endpoint.
Create a new tabular model in Visual Studio, enter an endpoint address.
Your model is in the Power BI Service, ready for further activities.