Topic: Power BI

92 results
  • UPDATE 2023-07-09: we now have a section “Creating sets of calculation items and measures” in the Inside Calculation Groups published in June 2023 that describes a technique also mentioned in the comments of this blog post. The consumption experience following…  Read more

  • At the end of March, we released the second update of SQLBI+ with a new session about different types of many-to-many relationships in DAX. The goal is to explain the difference between the many-to-many cardinality relationship available in Power BI…  Read more

  • If you create server aliases for SQL Server connections, you should be aware of the changes introduced in SQL Server 2022. At SQLBI we use aliases to identify the server’s name in the connection of our sample files (Power BI…  Read more

  • DAX Studio 3 released!

    DAX Studio 3 was released today. This new, major version offers a new user interface and user experience, providing a modern look and feel without losing any of the features available in previous versions. On the contrary, in DAX Studio…  Read more

  • When working on the Mastering Tabular video course, we needed a sample database with more data than what we had at our disposal in existing sample databases. We also wanted to be able to control the content so that different…  Read more

  • Did you ever experience a long waiting time while opening a Power BI Desktop file? There could be many reasons for that, but if you have calculated columns and/or calculated tables in your model, you should be aware that they…  Read more

  • Something really big is happening! The July 2020 version of Power BI Desktop allows you to create calculation groups in Power BI Desktop, thanks to the new “external tools” feature that enables the integration with Tabular Editor. We had been…  Read more

  • When you create and publish a composite model using DirectQuery for Power BI datasets and Analysis Services, you should pay attention to the minimal permissions required to consume data. For example, consider the following scenario: Base is a shared dataset…  Read more

  • At the end of a year marked by the pandemic, it is time for our usual review of what happened in the DAX realm. The enthusiasm we typically demonstrate in this traditional end-of -year post is tainted this year by…  Read more

Show more