PL-300 Exam - Question 139

Question

DRAG DROP -You have a Microsoft Excel spreadsheet named Excel1 that contains survey results. You have a Power BI dashboard named DashboardA that has Q&A enabled. You need to ensure that users who can access DashboardA can ask questions based on the contents of Excel1 and pin visuals based on their queries toDashboardA. The solution must minimize development time. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:.

Examice · Accepted Answer

Step 1: From powerbi. com, upload Excel1. Upload your Excel file to the Power BI service. The Power BI service connects to many data sources, including Excel files that live on your computer. 1. Sign in to the Power BI service. 2. In My workspace, select New > Upload a file. 3. Select Local File, browse to where you saved the Financial Sample Excel file, and select Open. 4. On the Local File page, select Import. Now you have a Financial Sample dataset. Power BI also automatically created a blank dashboard. If you don't see the dashboard, refresh your browser. Step 2: From powerbi. com, import Excel1 as a dataset. Step 3: From powerbi. com, add a tile for the Excel1 dataset to DashboarA. Reference:https://docs. microsoft. com/en-us/power-bi/create-reports/service-from-excel-to-stunning-report.

RickyAnd · Answer

"The solution must minimize development time", so:
1. format the data as a table
2. Import as a dataset (upload involves scheduling updates, whereas with import it updates automatically)
3. add a tile for the dataset to dashbard

PinkZebra · Answer

1. From Power BI, Upload Excel
2. Format Table
3. Pin
Instruction video from Microsoft Youtube Channel: https://www.youtube.com/watch?v=l8JoB7w0zJA

MoxieTT · Answer

If you have a look at the free, 50-question paper on Microsoft's website and also their 4-part prep video series for PL-300 located in the "readiness zone", they allude to the Ctrl+T shortcut to convert to table, in order to avoid an error when ingesting an Excel file. Also, if you read the difference between Upload and Import here: (https://biuniversity.wordpress.com/2017/03/08/powerbi-upload-excel-import-excel-differences/), it becomes clear, upload is the correct choice.
1. Format as table
2. Upload as Excel file
3. Pin tiles to DashboardA

FamousExam64 · Answer

it's a tricky question: 
because you cannot add a tile for a dataset.
1- format
2- upload
3- pin a range to dasboard.
but you not be able to use A&A and that the trick. it's just say has Q&A enabled not can you used it

evipap · Answer

I am sure that the 1st step should be: From Excel, format data as a table.
According to the following link this leads us to select as the 2nd step: From powerbi.com, Upload Excel.  https://learn.microsoft.com/en-us/power-bi/create-reports/service-from-excel-to-stunning-report
Now the 3rd step in my opinion is: Pin a range from excel to dashboard. Cause when we upload a file a dataset is not created. Source : https://biuniversity.wordpress.com/2017/03/08/powerbi-upload-excel-import-excel-differences/

lukelin08 · Answer

1. Format Table 
2. From Power BI, Upload Excel
3. Pin

poujor · Answer

Bad question
An uploaded Excel file can have a selection pinned. This does not support Q&A
An imported Excel file becomes a Dataset. But a dataset can not be pinned. You need to pin something from a report or run Quick Insight and pin from here.
So neither Upload or Import works as we need to pin something on the Dashboard to associate it to a dataset

UlyUkr · Answer

1. In Excel, format data as a table.
2. In Powerbi.com, upload excel file.
3. In Powerbi.com pin a range from excel to a Dashboard.
Tested it.

Shalaleh · Answer

I would go with 2-6-1
watch this video: https://www.youtube.com/watch?v=l8JoB7w0zJA
By the way, I do not have Get data or Import option in my Power BI Service.

albertcal · Answer

there are two ways this can be done
Method 1.  Dataset: It imports excel/CSV file as a dataset, which allows to create a report, then you can create a tile and pin to the dashboard. 
Solution is 2, 3, 4 (Most of people voted)
Method 2.  Upload as an Excel file. It brings just excel file to the workspace, But you CANNOT create any tiles, only you can format or define the range and pin to the dashboard. 
Solution is 2, 6, 1

9f73003 · Answer

1- From Excel, Formet the data in Excel1 as a table
2- From powerbi.com, upload Excel1
3- From powerbi.com, pin a range from Excel1 to DashboardA

https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel

slash_nyk · Answer

Bad question as you can never get the Q&A enabled.

The provided answer is kind ok 
1- Upload Excel File
2- Import file 
3- Pin

If you import as dataset then you cannot pin the visual directly

Vras · Answer

1. format the data as a table
2. Import as a dataset
3. add a tile for the dataset to dashboard

Vadimasss1234 · Answer

the question is not correct. 
I tried creating an simple excel and uploading it to powerbi service. It automatically creates a dataset, but then I couldn't find an option to pin anything durectly to dashboard. You first have to create a table saved in a report and then it can be pinned to a dashboard. pinning anything from a dataset with first creating a report looks not possible. 
If anyone can explain how it could be done,  I would be happy to hear.

MeHungarian · Answer

2-3-4 correct answer

LorryTheTruck · Answer

The option "Format the data as a table" should be: "Save the data as a table"

2c26c8e · Answer

I do not see any documentation for pinning dataset to dashboard, so I think we would need to upload the Excel so that pinning to dashboard can be done from the Excel..

PL-300 Exam - Question 139

Discussion