812 results
  • Don’t miss the upcoming free SQLBI live event on Friday April 16, 2021! Join Adam Saxton, Alberto Ferrari, Patrick LeBlanc, and Marco Russo to discuss common mistakes in big data models. Proper data modeling will be a hot topic in…  Read more

  • This article describes how to use DAX Studio to capture DAX queries generated by Power BI. Analyzing DAX queries can be helpful to better understand performance issues, and to improve the writing of DAX queries.  Read more

  • The SQL functions IN and EXISTS are useful to implement tests over a set of values. This article describes the corresponding syntax in DAX language.  Read more

  • USERELATIONSHIP lets you temporarily change which relationship is active. Even though USERELATIONSHIP is easy to work with in measures, it can be challenging and give you inaccurate results when used in calculated columns. In this article, we describe the details…  Read more

  • Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

Show more