-
This article describes the differences in the levels available in Azure Analysis Services (Azure AS), comparing them with the features in SQL Server Analysis Services (SSAS) on-premises. Read more
-
This article and its companion video describe how to create a service principal account to be used with the Power BI API. The reader must already be familiar with the Power BI API. Read more
-
This article describes the memory configuration in SQL Server Analysis Services and Azure Analysis Services. Modifying these settings may impact performance and memory errors. Read more
-
This article shows how to define variables in DAX queries and introduces the differences in scope when there are multiple EVALUATE statements. Read more
-
Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance and scalability than DirectQuery at the price of a small development cost. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro… Read more
-
The new video course to create enterprise-level solutions with Power BI and Analysis Services is available! Read more
-
This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Read more
-
Sorting a column by using another column is one of the nice features of the new version of PowerPivot introduced with SQL Server 2012 (we call it PowerPivot v2, but it really v11 because it is aligned with SQL Server).… Read more