Topic: Tabular

261 results
  • UPDATE 2021-06-29: also read Choosing Azure Analysis Services or Power BI Premium for large datasets – SQLBI containing updates about Power BI Premium Gen2. I often get questions about use cases for Azure Analysis Services. So I wanted to do…  Read more

  • Everyone using DAX is probably used to SQL query language. Because of the similarities between the Tabular data modeling and the relational data modeling, there is the expectation that you can perform the same operations as those allowed in SQL.…  Read more

  • This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is clear: a star schema is always the best choice.  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

  • This article explains how to avoid circular dependency errors that can occur in DAX when two or more entities (calculated columns or calculated tables) reference one another in such a way that the engine cannot compute their value.  Read more

Show more