Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Power Query parameters Transforming text columns 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…

Continue Reading... XMLA endpoints – Connecting to Data Sources
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide

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,…

Continue Reading... Power Query parameters – Connecting to Data Sources
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide

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…

Continue Reading... Using sensitivity labels – Using Data Model Advanced Features
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Power Query parameters

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…

Continue Reading... Implementing row-level security – Using Data Model Advanced Features
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Transforming text columns

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…

Continue Reading... Managing row-level security – Using Data Model Advanced Features
Posted in Examining data structures Microsoft Power BI Data Analyst Certification Guide Using sensitivity labels

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…

Continue Reading... Using advanced operations of Power Query – Cleansing, Transforming, and Shaping Data
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide

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…

Continue Reading... The Advanced section – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Power Query parameters

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…

Continue Reading... Configure table and column properties – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Transforming text columns

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…

Continue Reading... Relationship test tips – Designing a Data Model
Posted in Examining data structures Identifying data anomalies Microsoft Power BI Data Analyst Certification Guide Using sensitivity labels

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…

Continue Reading... Cardinality – Designing a Data Model