What is a limitation of using a live connection in Power BI?

What is a limitation of using a live connection in Power BI?

• A. Data can be transformed freely
• B. Relationships can be defined
• C. Transformations cannot be applied to data
• D. Data is stored locally

Answer: (C)

Using a live connection in Power BI allows for direct querying of data sources such as SQL Server Analysis Services, which means that any changes to the data must be done at the source rather than within Power BI itself. This connection type does not allow users to modify or transform the data directly in Power BI, which is a critical limitation. When utilizing a live connection, users can create reports and build visualizations based on the underlying data model available from the external source, but they cannot directly apply data transformations like they would in an imported dataset. Instead, the model and any transformations need to be handled within the original data source prior to establishing the live connection. This means that all calculations, filters, and other data modifications must be set up in the data source or pre-processed before they can be visualized in Power BI. The other options suggest capabilities that either do not apply to a live connection or are features that are applicable in scenarios where data is imported into Power BI, making them not relevant to this specific limitation.

Using a live connection in Power BI allows for direct querying of data sources such as SQL Server Analysis Services, which means that any changes to the data must be done at the source rather than within Power BI itself. This connection type does not allow users to modify or transform the data directly in Power BI, which is a critical limitation.

When utilizing a live connection, users can create reports and build visualizations based on the underlying data model available from the external source, but they cannot directly apply data transformations like they would in an imported dataset. Instead, the model and any transformations need to be handled within the original data source prior to establishing the live connection. This means that all calculations, filters, and other data modifications must be set up in the data source or pre-processed before they can be visualized in Power BI.

The other options suggest capabilities that either do not apply to a live connection or are features that are applicable in scenarios where data is imported into Power BI, making them not relevant to this specific limitation.