Exam PL-300 All QuestionsBrowse all questions from this exam
Go to Exam
Question 28

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.

    Correct Answer:

Discussion
jl234

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.

edbf978

Thanks for your answer! I am a bit confused by the need for direct query. I see this requirement: "The solution must ensure that you can publish a separate report and dataset." So does using direct query stop the two semantic models from merging or something? The question doesn't say anything about required real-time elements so I don't understand why direct query is needed unless it relates to the separation of report and dataset. Otherwise seems like something you would decide based on size of data source and the real time accuracy requirement from the business... But I have never published a dataset without a report so I am not knowledgeable on the subject..

JudT

Load and Transform Data in Power Query. Close and Apply your power query Logic in PBI. Build your semantic model and publish it on service without any reports. Open a new PbI instance and connect to your pulished semantic model (via Get Data Menu and select Power BI semantic Models) and a connected live mode will be etablished. This is the best way to achive this requirement. Hope this will help.

INDEAVR

I think what they meant to say in this question is that you need to split the report and the dataset and publish them to Service separately: https://learn.microsoft.com/en-us/power-bi/guidance/report-separate-from-model I have done this many times and the solution is: 1. You split your pbix to a report pbix and a dataset pbix 2. You publish the dataset to Power BI service. 3. You live connect your report to the Power BI dataset and then publish it as well. https://powerbi.tips/2020/06/split-an-existing-power-bi-file-into-a-model-and-report/ So the correct answer is: Report => Liveconnect Dataset => Import Technically, the dataset may use any other connection type but in this case I think it is Import.

JudT

I agree. Thank you for your contribution

Shree07

This is the correct answer. If we have a separate dataset and a report connecting to this dataset then it would be a Live connect and the Dataset can be Import.

Mo2011

Wrong answer, THERE IS NO DIRECT QUERY FOR EXCEL FILES, ONLY IMPORT MODE

Jane97

Dataset: Direct Query. To keep the data in OneDrive and maintain a live connection to the source, you should use Direct Query for the dataset. Direct Query 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

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

Leopards

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.

pscbs

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)

jsav1

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.

Chellz

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.

Chellz

On June 8, 2024 exam. Don't like this question :( I left feedback on this one after the exam

9f73003

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

Aero_1898

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

28485e1

This was on my test, 2/2024.

niceguysfinishlast

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

agelee

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

ak57

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

Smyrol

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

4r3k

Copilot says: B

4ae4e69

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.

55884

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!

9f73003

You have this backwards, the report uses the liveconnect!

SilentAnalyst

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

da66a09

shouldn't it the other way round? you wouldn't import the data into the report. you would just connect to the published dataset Report = Live Connection Dataset = Import "Live connection is a way of connecting a Power BI report to a published Power BI semantic model." Source = https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets