Category: Examining data structures
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…
Power Query parameters – Connecting to Data Sources
Power Query parameters For data connection and transformation, Power BI uses a technology called Power Query. Power Query is a key component of Power BI,…
Using sensitivity labels – Using Data Model Advanced Features
Using sensitivity labels As part of the holistic data protection capabilities, Power BI includes integration with Microsoft Information Protection (MIP). MIP provides sensitivity labels as…
Implementing row-level security – Using Data Model Advanced Features
Implementing row-level security A common security need for customers building reporting solutions with Power BI and needing to simplify the data model is a way…
Managing row-level security – Using Data Model Advanced Features
Managing row-level security In Power BI Desktop, you can manage roles and the DAX expression applied to each role by clicking Manage roles under the…
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…
The Advanced section – Designing a Data Model
The Advanced section In the Advanced section, you can choose to sort one column by another column in the same table. A common use for…
Configure table and column properties – Designing a Data Model
Configure table and column properties Once we have our relationships sorted, we can take a peek at our table and column properties. In Power BI…
Relationship test tips – Designing a Data Model
Relationship test tips Here are some tips for managing table relationships: Define role-playing dimensions If you are used to using star schemas, one of the…
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…