Member-only story
How to refresh a single table in Power BI using SSMS
A short guide to selectively refresh tables in Power BI datasets with XMLA endpoints
This article is also available at bits 2 BI
Refreshing the entire dataset in Power BI is not always desirable or sometimes even unnecessary. Unfortunately, Power BI Service doesn’t provide an option to refresh tables selectively. Either you refresh all the tables or none. XMLA endpoints address this shortcoming and provide a flexible and fine-grained option to refresh (among other things) datasets, tables, and partitions.
XML for Analysis (XMLA) is a protocol for communication between client applications and an Analysis Services instance such as Azure Analysis Services, SQL Server Analysis Services, and Power BI.
This article discusses the requirements, limitations, and steps to selectively refresh tables in Power BI datasets using SSMS with XMLA endpoints.
Please read our terms of use before proceeding with this article: https://dhyanintech.medium.com/disclaimer-disclosure-terms-of-use-fb3bfbd1e0e5
Pre-requisites
Connecting to XMLA endpoints and refreshing a table is relatively straightforward. However, the following pre-requisites need to be fulfilled.
