Category: Using sensitivity labels
XMLA endpoints – Connecting to Data Sources
XMLA endpoints XMLA is the communications protocol used by Microsoft SQL Server Analysis Services instances. XMLA is a widely used connectivity option supported by many…
Design the data model to meet performance requirements – Designing a Data Model
Design the data model to meet performance requirements As mentioned previously, model performance is extremely important. A faster rendering report is a much more enjoyable…
Using advanced operations of Power Query – Cleansing, Transforming, and Shaping Data
Using advanced operations of Power Query Power Query is truly a powerful tool for data transformation that helps to enable capabilities that often meet all…
Cardinality – Designing a Data Model
Cardinality Power BI relationship cardinality decides which table filters the other. There are three possible cardinalities. Many-to-one (*:1) and one-to-many (1:*) This is a relationship…
Using merge queries – Cleansing, Transforming, and Shaping Data
Using merge queries Merge queries are used when we want to merge or combine columns from multiple queries where some columns are different. This often…
