In Live Connection, where are all transformations applied?

In Live Connection, where are all transformations applied?

• A. On the Power BI side
• B. On the application side
• C. On the source side
• D. On the user interface

Answer: (C)

In a Live Connection scenario, all transformations are applied on the source side. This means that when Power BI connects to a data source in a live scenario, it does not import the data into Power BI for processing. Instead, it sends queries directly to the data source, such as a SQL server or Analysis Services, and receives the results back in real time. By applying transformations at the source, you ensure that the data is processed efficiently, leveraging the computing power and optimization of the data source. This is particularly beneficial for performance, as it minimizes the amount of data transferred over the network and utilizes the powerful processing capabilities of the data source. In contrast, the other options involve data processing that would not typically reflect the real-time analytics and performance enhancements that a live connection provides. Transformations on the Power BI side would involve importing and pre-processing data, which is not the case in a live connection. Similarly, application-side transformations or transformations at the user interface would not deliver the same performance or reflect the current state of the data as effectively.

In a Live Connection scenario, all transformations are applied on the source side. This means that when Power BI connects to a data source in a live scenario, it does not import the data into Power BI for processing. Instead, it sends queries directly to the data source, such as a SQL server or Analysis Services, and receives the results back in real time.

By applying transformations at the source, you ensure that the data is processed efficiently, leveraging the computing power and optimization of the data source. This is particularly beneficial for performance, as it minimizes the amount of data transferred over the network and utilizes the powerful processing capabilities of the data source.

In contrast, the other options involve data processing that would not typically reflect the real-time analytics and performance enhancements that a live connection provides. Transformations on the Power BI side would involve importing and pre-processing data, which is not the case in a live connection. Similarly, application-side transformations or transformations at the user interface would not deliver the same performance or reflect the current state of the data as effectively.