Exam PL-300 topic 1 question 28 discussion

Report file: Import: In Power BI, when you import data, it means that the data is loaded into the Power BI Desktop file. In this case, you would import the data from both Excel workbooks into your Power BI Desktop report file. This allows you to create visuals and reports based on the imported data. Importing the data ensures that you can work with the data even when you're not connected to OneDrive. Dataset: DirectQuery: To keep the data in OneDrive and maintain a live connection to the source, you should use DirectQuery for the dataset. DirectQuery allows Power BI to retrieve and query data from the original data source (in this case, the Excel workbooks in OneDrive) in real-time without importing it into the dataset. This ensures that your dataset is always up-to-date and reflects changes made to the source data.

The question is not very clear. I would do it this way: 1 Import by Dataset 2 Live connect (to dataset) for report(s).

Why this setup works: Import mode is ideal for Excel files stored in OneDrive — Power BI can refresh them automatically in the cloud. Live connection allows you to build multiple reports on top of a single dataset, minimizing development effort and ensuring centralized data governance. This approach aligns with best practices for separating semantic models (datasets) from report layers, especially in enterprise or team-based environments. Would you like help setting up the live connection or combining the Excel tables in Power Query? I can walk you through it! 📁📊

Report file: Live Connection Once the dataset is published, the report file should use Live Connection to reference the dataset from Power BI service instead of importing the data again. Dataset File: Import Since Power BI does not support DirectQuery for Excel files in OneDrive, you must import the data.

Answer is correct because when you import a report file (.PBIX) while using DirectQuery to a dataset, you’re essentially separating report development from the dataset model. Even though the report file is in import mode, it doesn’t necessarily mean the underlying data is imported. If the report is built on a DirectQuery dataset, the visualizations still pull live data from the dataset, ensuring real-time updates. The imported PBIX file only contains the report layout, filters, and visuals, keeping it lightweight while leveraging the external dataset for calculations and queries.

Direct Query does not support excel files. I think both will be import

Dataset File—Import Mode: Using import mode means the data from both Excel files is brought into the Power BI dataset. This allows the combining of the two Sales tables into one table, scheduling refreshes (so the dataset is updated daily or as required), and maintaining full control over the data transformations. Note that Import mode truly “stores” a copy of the data in the dataset (but this is acceptable because the requirement is to have the combined data available for reporting). Report File—Live Connection: For the report file, if connected live to the published dataset, then the visuals are based on the dataset that is kept up-to-date via scheduled refreshes. A live connection does not store any additional data in the report file; it simply points to the dataset. This gives the flexibility to publish the report and dataset as separate assets and ensures that any updates in the dataset are immediately available in the report visuals.

Both import. Direct Query doesn’t support sharepoint folder/files.

Dataset File: Import Mode Report File: Live Connection Excel doesn’t support DirectQuery, so Import Mode is required for the dataset. Live Connection lets the report use the published dataset without duplicating data. Push Mode isn’t relevant (used for real-time streaming, not Excel).

both answers are import you can check on microsoft learn

I think DirectQuery connection is available when connecting to an excel workbook when is hosted in OneDrive or Sharepoint but it's not clear report must be connected to the Dataset or to excel file. Since there is a Dataset (current Semantic Model), I would move for the Import mode for the report unless any size constraint as it would optimize render of the visuals. For the Dataset, I guess you could set up DirectQuery connection to ensure data is updated without any other refresh action but, again, there are no requirements about size, performance... to clearly decide between Import or DirectQuery. "Live Connection" is a method to build a report in PBI Desktop without having to build a Semantic Model... this could be the answer for the report in case we could understand the requisite "...publish a SEPARATE report and dataset" means report and dataset should be not connected

Para esta pregunta, la mejor respuesta sería: Report file: LiveConnect Dataset file: Import Explicación: Dataset (Import): Este archivo debe configurarse en modo Import, ya que estamos tratando con datos estáticos en archivos de Excel almacenados en OneDrive. El modo Import permite cargar y almacenar los datos en el modelo de Power BI, facilitando la creación de un conjunto de datos independiente y optimizando el rendimiento para análisis rápidos. Report (LiveConnect): En el archivo de informe, configuramos LiveConnect, lo cual permite conectarse dinámicamente al conjunto de datos importado. Esto asegura que cualquier cambio en el conjunto de datos se refleje automáticamente en el informe sin necesidad de replicar los datos. Esta configuración permite un informe independiente del conjunto de datos, minimizando el esfuerzo administrativo y optimizando el rendimiento.

Excel file stored in one drive is not same as an excel file on your desktop. Live connect can be used with onedrive url to source the excel data. So the answer is live Connect for Dataset, and import for Report file

Report file: Import Dataset file: Import The question said there are two Microsoft Excel workbooks in a Microsoft OneDrive Folder which requires an Excel connector (or Web). NOTE: Excel connector only supports the Import storage mode

Import, DirectQuery

1. Report file: LiveConnect 2. Dataset file: Import

It's import to the dataset and then live connection to report that's how we build it at work