How to Cancel a Power BI Refresh

In Power BI Premium, the XMLA endpoint enables many operations previously unavailable – one being the ability to cancel a dataset refresh. To do so, you’ll need to be a workspace admin and launch a few commands from SQL Server Management Studio (SSMS). First, use SSMS to connect to the XMLA endpoint (you can learnContinue reading “How to Cancel a Power BI Refresh”

What is XMLA and why should you care?

XML for Analysis was defined back in 2001 as a standard way to access and manage analytic systems. A good metaphor for XMLA is its cousin SQL – SQL is a standard approach in relational systems for both querying and defining relational objects. Like SQL, XMLA is that but for analytical systems. (Well, almost. More aboutContinue reading “What is XMLA and why should you care?”

Migrating from Azure Analysis Services to Power BI Premium

Power BI Premium support for the XML for Analysis (or XMLA) protocol is in public preview. XMLA is an industry standard for data access for analytic client and management applications (and has been an open standard for almost 20 years). Azure Analysis Services and SQL Server Analysis Services both use the XMLA protocol for communicationsContinue reading “Migrating from Azure Analysis Services to Power BI Premium”

Processing Parallelism, Explained

Understanding how parallelism works when your tabular model gets processed is confusing. How can parallelism be increased? Where are the potential bottlenecks? Before we get into how parallelism works, there are several different types of jobs that happen and each is handled a bit differently. Let’s look at these different jobs that run when aContinue reading “Processing Parallelism, Explained”

Power BI Approximate Distinct Count and Aggregations

Distinct count is a common use case for analytics – show me someone with a web site or service and I’ll show you someone that wants to know how many unique customers they have. The problem with distinct count is that it’s expensive with respect to both CPU and memory. When you have datasets inContinue reading “Power BI Approximate Distinct Count and Aggregations”

Power BI Exact Distinct Count and Aggregations

It’s not news that Power BI supports aggregations. What might be news is that these aggregations support distinct count measures. Today. The aggregation dialog has “Summarization” method. If you select “GroupBy” as the summarization method for a column, not only are all unique values of the column retained, but Power BI is clever enough toContinue reading “Power BI Exact Distinct Count and Aggregations”