pl-300 Practice Question 1926
Exam: pl-300
Domain: Prepare the data
Topic: Get data from different data sources
Difficulty: medium
An organization wants to integrate data from multiple sources into a single Power BI report, including a local Excel file and a live connection to an Azure SQL Database. To ensure that the Excel data is refreshed manually while the SQL data is refreshed automatically, what approach should be taken using Power Query in Power BI Desktop?
Answer Options
A
Use Import mode for both data sources
B
Use DirectQuery mode for both data sources
C
Use Import mode for the Excel file and DirectQuery for the SQL Database
D
Use Power Query mode for both data sources
Correct Answer
C: Use Import mode for the Excel file and DirectQuery for the SQL Database
Explanation
The analyst should use the 'Get Data' feature in Power BI Desktop to import the Excel file in Import mode and then use DirectQuery for the Azure SQL Database. This way, the Excel data can be refreshed manually, and the SQL data can be refreshed automatically without affecting the performance of the existing reports. Using Import mode for both would not allow automatic refreshing for the SQL data, and using DirectQuery for both would not allow manual refreshing for the Excel data.