What is Dataset connectivity with the XMLA endpoint? | PL-300 Tutorials Ep13

What is Dataset connectivity with the XMLA endpoint in Power BI? | PL-300 Tutorials Ep 13| Power BI
Power BI Premium workspaces and datasets at the 1500 and higher compatibility level support open-platform connectivity from Microsoft and third-party client applications and tools by using an XMLA endpoint.
In this video, I have explained XMLA Endpoint connectivity in Power BI, what is it, how to optimize it, and how to connect with SSMS.
👉👉 Reference:
docs.microsoft...
PL-300 Exam Sample Questions & Answers:
👉👉 PL-300 Exam Sample Questions: biconsultingpr...
*****************Free Video Tutorials*************
Power BI Interview Questions: • Power BI Interview Que...
Microsoft Fabric Tutorial: • Microsoft Fabric Tutorial
DP-600 Tutorial: • DP-600 Certification T...
DP-203 Tutorial: • DP-203: Data Engineeri...
AZ-900 Tutorial: • AZ-900: Microsoft Azur...
PL-300 Exam: • PL- 300 Exam Tutorial
Power BI Tutorial for Beginners: • How to get started wit... ​
Free Power BI Admin Tutorial: • How to use Power BI ad...
Free DAX tutorial: • Complete DAX Course - ...
Power BI Service Tutorial: • What is Power BI Servi...
Power BI Data Modeling Tutorial: • What is Data Modeling?...
Power Query Tutorial: • What is Power Query? H...
RLS In Power BI: • RLS in Power BI
Migrate to Power BI: • Migrate to Power BI
How to choose Power BI License? - • How to choose a Power ...
Demystifying Power BI Licenses: • Demystifying Power BI ...
Top 5 Reasons to say Good Bye Power BI Premium: • Do you really need Pow...
************************************************************************
☎️ LET'S CONNECT!
************************************************************************
📧 Email: [e-mail]
📺TH-cam: / @biconsultingpro
🧰LinkedIn: / biconsultingpro
🐥 Twitter: / biconsultingpr1​
📱 Instagram: / biconsultingpro
➥ Facebook: / biconsultingpro
🧑‍💻 Website: biconsultingpr...
~-~~-~~~-~~-~

[@oladman9058]

Worked perfectly for me. Many thanks and God bless.

[@sonash4662]

Very well explained! I was trying to understand XML end points using different available articles but your demo made my concepts on xml very clear. Thank you very much!

[@2013Nicomusic]

Excelent! Thanks you for to share your knowledges!

[@BIConsultingPro]

Glad it was helpful!

[@DanielWeikert]

Interesting thanks. Now what kind of updates/modifications,... can we do using the endpoint now? What kind of interesting use cases are there

[@BIConsultingPro]

This depends on your use case. For example, you can create measures, calculation groups using Tabular Editor, you can delete a dataset or you can insert some records. Even people use XMLA end points to insert or delete rows into the datasets using their onw applications.

[@L.ahmad2958]

@@BIConsultingPro
Thank you for your efforts, I have a question for you, if you do a change into the dataset using XLMA end point, we won't be able to download it, is there a way to solve this issue, any thoughts?
Thank you in advance

[@nidhi5823]

Very nicely explained..

[@ismafoot11]

I'm having the following error message when connection to the Analysis Services server:
The integrated security 'ClaimsToken' is not supported for native connections. (Microsoft.AnalysisServices.AppLocal.AdomdClient)

[@satyabobby6248]

Pls reply, What is the use of this XMLA end point.

[@BIConsultingPro]

I have already replied… XMLA connection can be used to connect with third party tools such as DAX Studio, SSMS or tabular editor. Also apps such as ALM toolkit to perform activities such as deployment on Power BI Service

[@zuah04881]

How do I setup gatway connection to schdule refresh for XMLA ,

[@BIConsultingPro]

You just need to install Power BI Standard Data Gateway on a Server or Machine that is available online 24X7 or at least on at the time of Data Refresh.
Also, XMLA refresh can be achieved via SQL Server Jobs or you can do it manually via SSMS

[@tahamansoor599]

please upload the remaining videos of DA-100 updated exam, im scheduling my exam next week

[@BIConsultingPro]

All videos have been already updated. The most important one was XMLA endpoint. This weekend I'll upload a "paginated report " video as well.

[@tahamansoor599]

@@BIConsultingPro Thank you

[@mnesevati]

Hi Dear, thanks for this valuable and useful information, I have a question: is there a way to allow the users who are shared with them the dashboard to change some table figures, as I need them to update the projections by the monthly base for instance. then When they update the figures, it's automatically reflected in the datasets....I hope I can deliver my point to you

[@BIConsultingPro]

Yes, You can but for that first, you need to create either your own app or a Power App. Once you have this, you can perform read/write operations.

[@Virupaksha1503]

Hi, we are facing a typical issue where we are trying to convert SSRS reports of 2012 version which use semantic model, to Power BI, so these SSRS reports use Semantic Query to connect to the database but they are not supported in Power BI. Any idea how can we convert these semantic queries from XML to SQL Query or MDX

[@BIConsultingPro]

Are these Semantic Queries in SQL or XML?