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).

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

Copilot says: B

You cannot create a DirectQuery / Live connection to an Excel spreadsheet per Microsoft's documentation on Power BI data sources. For excel it seems the mode is import.

You need to publish the report and dataset separately, i.e. they are not in the same pbix. The dataset would use import but once it is published into the Power BI Service the report uses a live connection to the dataset.

In this video it says both are : Import I don't see anyone given this answer in the discussion.

The answer provided is rubbish! A standalone report file uses a liveconnect stoage mode!! The dataset imports.

I would say its: report file: import dataset file: liveconnect report: this is because there were no requirement for real-time and due to the requirement's complexity (combining 2 tables into 1 table) THEN visualize the data. we use import to reduce their high complexity by setting report storage mode as import. dataset: due to the question's requirement "create visuals based on the data in the table", there were no semantic model in the picture. so, liveconnect will be the most suitable because liveconnect can create the visuals/report directly from the existing data without the need of semantic model (unlike directquery where it connects the semantic model to data). this is my reference: https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets correct me if I'm wrong!