What should be the data connectivity mode for a historical report that is produced monthly?

What should be the data connectivity mode for a historical report that is produced monthly?

• A. DirectQuery
• B. Import Data
• C. Export as CSV
• D. Live Connection

Answer: (B)

The data connectivity mode for a historical report that is produced monthly should be Import Data. This mode is ideal for scenarios where the data does not change frequently and can be preloaded into Power BI. When using the Import Data mode, the data is loaded into the Power BI Desktop model, allowing users to interact with the data quickly, as it is stored in-memory. For monthly reports, this means that the data can be refreshed at defined intervals to capture the latest historical data, but is primarily focused on static data within defined reporting periods. Additionally, Import Data is effective for creating complex calculations and visualizations without relying on a live connection to the data source, which can introduce performance lags and dependence on the source system's availability. With a historical report, where consistent access to a snapshot of the data over time is essential, the Import Data method aligns perfectly with these requirements. In contrast, other options have limitations for this use case. DirectQuery involves querying the database in real-time, which may not be necessary for historical data and can lead to performance issues if the queries take time to return results. Live Connection is similar and is used primarily for real-time connections to services like SQL Server Analysis Services, likely unnecessary for reports generated monthly. Export

The data connectivity mode for a historical report that is produced monthly should be Import Data. This mode is ideal for scenarios where the data does not change frequently and can be preloaded into Power BI.

When using the Import Data mode, the data is loaded into the Power BI Desktop model, allowing users to interact with the data quickly, as it is stored in-memory. For monthly reports, this means that the data can be refreshed at defined intervals to capture the latest historical data, but is primarily focused on static data within defined reporting periods.

Additionally, Import Data is effective for creating complex calculations and visualizations without relying on a live connection to the data source, which can introduce performance lags and dependence on the source system's availability. With a historical report, where consistent access to a snapshot of the data over time is essential, the Import Data method aligns perfectly with these requirements.

In contrast, other options have limitations for this use case. DirectQuery involves querying the database in real-time, which may not be necessary for historical data and can lead to performance issues if the queries take time to return results. Live Connection is similar and is used primarily for real-time connections to services like SQL Server Analysis Services, likely unnecessary for reports generated monthly. Export