Topic: Power BI
-
Explore the differences between GENERATE and CROSSJOIN while discovering different solutions to solve a business problem described during the Guy in a Cube Q&A Live of October 9, 2021. The question was how to match employees with skills at a… Watch now
-
This article describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. Read more
-
This video describes how to enable the Single Value slicer option in Power BI by adding additional metadata to the model with Tabular Editor. Watch now
-
This article describes what limited relationships are and the differences between regular and limited relationship in Power BI and DAX. Read more
-
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. 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
-
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. In this article we introduce the architecture of push datasets. Read more
-
Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined with an Import model already in place. This video introduces the architecture of push datasets. Watch now
-
In this article we perform a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option. Read more
-
In DAX, optimizations and data types do not always play nice and can leave you dealing with surprises. In this short article, we see an example of how mixing blanks, Boolean logic, and comparison with TRUE might lead to unexpected… Read more
