PL-300 Exam - Question 28

Question

DRAG DROP-You have two Microsoft Excel workbooks in a Microsoft OneDrive folder. Each workbook contains a table named Sales. The tables have the same data structure in both workbooks. You plan to use Power BI to combine both Sales tables into a single table and create visuals based on the data in the table. The solution must ensure that you can publish a separate report and dataset. Which storage mode should you use for the report file and the dataset file? To answer, drag the appropriate modes to the correct files. Each mode may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Examice · Accepted Answer

.

jl234 · Answer

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.

Hyla · Answer

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

pscbs · Answer

It is not possible to DirectQuery an excel file - this is only for databases or APIs which support it.
Your dataset should use import - it will import the excel data into the PBI service.
Your Report should connect to that dataset, and by default that's done with DirectQuery mode since the data is already in the native PBI format after it's been imported by the service. (you can also import in your report, but it would be redundant)

Leopards · Answer

https://www.youtube.com/watch?v=1RWHocvfvvs
In this video it says both are : Import
I don't see anyone given this answer in the discussion.

Chellz · Answer

The Storage mode is for TABLES in your model. The question asks that you must be able to publish a separate report and dataset. That means the 2 tables must be imported to the model. However, report and dataset are the instances that you publish to Power BI Service workspace. There's no storage mode property that you can set for report and dataset.

jsav1 · Answer

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.

Aero_1898 · Answer

Report either Live or Direct and dataset should be import because you can create daxs in the dataset and publish it and for the report you can connect it with the dataset via live or direct or dual and publish it

9f73003 · Answer

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

28485e1 · Answer

This was on my test, 2/2024.

SilentAnalyst · Answer

I think the write answer is:
Report file: Import
Dataset file: LiveConnect

Remember that we want to have a 'separate report' and dataset.
For this to work we first the two Excel files to the Power Bi Desktop (do whatever we need to do to transform and prepare it). and this without any reports publish it to the Power Bi Services.

Now we have a semantic model and a report (and empty report) on the workspace of Power BI services. we don't need the report and we can just delete it.

Now in power BI we open a new document and select 'Get Data'>'Power BI datasets' and choose the semantic model that we just published. This is going to be a Liveconnect and I think this is the only way we can connect to a semantic model on Power BI services (if anyone knows any other way, tell me).
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

55884 · Answer

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!

4ae4e69 · Answer

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.

4r3k · Answer

Copilot says: B

Smyrol · Answer

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

ak57 · Answer

There is no direct query for excel files. So the only option is IMPORT. Please see the detailed video here: https://youtu.be/1RWHocvfvvs?si=agZkA2RNZWFsCPiE

agelee · Answer

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

niceguysfinishlast · Answer

Both Import.
Thank me later https://www.youtube.com/watch?v=1RWHocvfvvs

PL-300 Exam - Question 28

Discussion