Power BI Certification Practice Exam

When using a Live Connection in Power BI, the primary method of accessing data is via a direct link to databases like SQL Server Analysis Services (SSAS) or Azure Analysis Services. This means that the data remains in its source location, and Power BI queries this data in real-time without importing it into the Power BI dataset.

In this scenario, transformations like adding custom columns or unpivoting columns cannot be applied directly within Power BI as they would be with imported data. Instead, any required transformations must be defined and performed at the source level or through the data model of the connected server.

As such, the option indicating that no transformations can be made directly in Power BI under a Live Connection setup is correct. Data handling in this context is typically limited to what is pre-defined in the source system or data model, reinforcing the statement that none of the listed transformations can be performed.