Which of the following can be considered a limitation when using Live Connection?

When using a Live Connection in Power BI, one of the primary limitations is that no data transformations are allowed. This means that, unlike when working with Power BI Desktop where you can modify, clean, or reshape data creatively using the Power Query Editor, you are restricted from making any such changes in the Live Connection mode. The underlying data model is handled entirely on the server side, and users are unable to directly manipulate the data within Power BI.

This limitation emphasizes that users must prepare their data adequately in the source system before connecting to it in Power BI. So, the importance of having a well-structured and clean data source becomes critical, as any desired transformations or modifications need to be performed at that level, and are not possible within the Power BI environment itself when utilizing a Live Connection.

Understanding this limitation reinforces the need for proper data management practices, as Power BI will reflect exactly what is provided by the data source without the flexibility of transforming data within the reporting environment.