Explaining the XMLA Endpoint and its Use Cases (with Just Blindbaek)

Power BI is merging with Azure Analysis Services! Microsoft is now opening up and giving us full access to the powerful Analysis Services engine in the Power BI service. This gives us semantic models that serve as the single source of truth for the whole enterprise. Manage the models (datasets) with the tools you know and love and give read and write access to a variety of Microsoft and third-party client tools.
GUEST BIO 📄
Just Blindbaek is an independent BI consultant with extensive experience in all phases of BI development on Microsoft SQL Server, Azure and Power BI. Founder and coordinator of Microsoft Business Intelligence Professionals Denmark (MsBIP.dk) and Power BI UG Denmark (PowerBI.dk).
RELATED CONTENT 🔗
Just's Twitter -- / justblindbaek
Just's Website -- justb.dk
XMLA Blogpost -- justb.dk/blog/2020/04/use-cas...
Power BI Next Step Conference -- powerbinextstep.com/
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #xmla #premium #premiumperuser #ppu

[@wayneedmondson1065]

Interesting talk. Thanks for sharing. Thumbs up!!

[@thomothomo9802]

Hi,
Can you Automate the xmla endpoint refresh to run every 5 or 10 minutes in SSMS rather than manually

[@ifernandoubbi]

First you have to create a linked server to SSAS (from SQL MS)but I think this is not possible with the new Power BI service.

[@HariharasudanP]

Havens consulting team - Nice one.. could you pls share how to write some where clause kind of in partition and create smaller one and larger(historical - no refresh daily)? Any reference link to get sample code pls

[@edavidzh]

Great session. Thank you guys! qq: can your impact active processes (stop user query, stop data refresh) running on Premium Capacity. Scenario: mu premium capacity overloaded and I want to kill some specific active workloads.

[@HavensConsulting]

I don't believe you're able to kill specific processes once they've started (e.g. data refreshes). Though I'd consider sending Just a message directly on LinkedIn and asking him there as well :)

[@remek5758]

Hey, I’m having bad request (400) when I try to connect to my dataset on PBI service using XMLA, I tried all tools and its the same (Tabular editir, SSMS, Alm toolkit, Dax studio) it is working for others but not me, any idea whats the reason behind it?

[@HavensConsulting]

Thanks for the question. It is in a premium or premium capacity workspace and XMLA is enabled from your admin Power BI tenant settings?

[@remek5758]

@@HavensConsulting It's Premium, It should be turned on because my colleague can access it (I Can't see the tenant setting on this matter because I'm not an Admin, I already asked them to check) may this be an issue where I'm not listed under a group who can access it through XMLA?

[@krishnakoirala2088]

I am always getting error says: The connection string is not valid. I am pretty sure I have got the correct url and did as in the demo. What could be the issue?

[@HavensConsulting]

Is the XMLA endpoint enabled in the global admin settings for your tentant?

[@krishnakoirala2088]

@@HavensConsulting Yes, it is enabled read/write. I can connect it from SSMS and can do manual refresh of each tables/partitions though.

[@HavensConsulting]

@@krishnakoirala2088 thanks for the clarification. Without looking at the query string, global admin settings, etc. it's really hard to determine what could be the issue. We do offer help desk hours for such things if you're looking for further assistance! www.havensconsulting.net/contact-and-support

[@Phoenixspin]

I have no idea what you are talking about.

[@HavensConsulting]

Thanks for commenting. Would you mind elaborate on specifically what you don’t understand? Just does a thorough job of walking through both what the XMLA endpoint is, and multiple use cases for how to use it