XMLA End Points in Power BI

Welcome to the fifth episode of my new segment called “Talk with Devs”. During this session, we will talk about one complete real-life use case using XMLA End Points with Power BI. Sometimes we have a scenario wherein we need to connect Power BI Dataset to other tools like SSMS, MDX Studio, SQL Profiler at that time, XMLA End Points helps us a lot. Sometimes, we want to make some cube and publish to Power BI, at that time as well XMLA End Points helps us a lot. To present all these things with us today, we have our industry expert Mr. Abhinav Singh with us! During this session, first of all, we will try to understand the concept of XMLA End Points in Power BI. What is XMLA End Point and what are different Real-Life Use cases for XMLA End Point? Then we will create one Power BI Premium Workspace and get XMLA End Point from our Workspace. After that we will connect our XMLA End Point with SQL Server Analysis Service in Power BI. Then we will try to understand our first use case where we can perform all operations to our Power BI Dataset, which we were doing with Analysis Service (e.g. Refreshing Specific Table from Power BI Dataset using XMLA, Process Tabular Model). Then we will check our second use case where we will learn how we can use Power BI as storage and call custom APIs to get data and connect any third-party applications with it? You will get all answers throughout this session! During this session we will learn the following concepts: 1. What is XMLA End Point in Power BI? 2. Why to use XMLA End Point in Power BI? 3. Real Life Use Cases for XMLA End Points in Power BI 4. Connect Power BI Dataset with SSAS using XMLA End Point 5. Call Custom API from XMLA End Points 6. How to work with Client Libraries with Power BI Dataset? Chapters: 00:00 Start 00:45 Introduction of Abhinav Singh 02:18 QnA with Abhinav 05:22 What is the Agenda for today's Session! 07:17 Where we can use XMLA End Point in Real-Life Business? 09:27 XMLA End Point Availability 13:00 How to Set Up for XMLA End Points? 14:05 Get XMLA End Point for WorkSpace 14:30 Connect XMLA End Point with SSMS 15:30 Check all Power BI DS Table from SSMS Analysis Service 16:12 Capability for XMLA End Point from Analysis Service 17:40 Create Cube in Power BI from Analysis Service 19:18 Power BI Loves SSAS Cube with XMLA End Point 20:30 Refresh Only Specific Table from Dataset using XMLA End Point 21:52 Connect SQL Server Profiler with Power BI Dataset 23:46 MDX Connection with XMLA End Point 24:08 Working with Client Libraries with Power BI Dataset 25:13 Create .NET CORE API 25:35 Install Nugeget Package for ADOMD Client 26:30 Get Product from Power BI Dataset using XMLA End Points 30:03 Run Result 32:10 When to use XMLA End Point - Use Case 01 36:48 Document Power BI Report with API using Client Libraries 40:40 End Outcome 42:16 Important Points - Power of XMLA End Points 44:18 Host Analysis Service Cube in Power BI 47:05 Summary for XMLA End Point 48:21 Overall Summary for Session 50:12 Subscribe! *********************************** CREDIT and Special Thanks for the session: Speaker Name: Abhinav Singh LinkedIn: https://www.linkedin.com/in/abhinav-singh-22426b37/ Abhinav's Community Profile: https://community.powerbi.com/t5/user/viewprofilepage/user-id/12124 ********************** Follow me on Instagram: https://www.instagram.com/powerplatformguy/ Looking for Consultancy? Connect Here! https://powerplatformtrainings.com/contact/ Follow me on all social Media Handles: https://linktr.ee/dhruvin.shah #PowerBI #XMLA #PowerPlatform #MSBI #SSAS #ClientLibrary #PowerAddicts #PowerBIWithDhruvin #TalkWithDevs #DigitalDhruvin #Microsoft