ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 3 question 21 discussion

Actual exam question from Microsoft's PL-300
Question #: 21
Topic #: 3
[All PL-300 Questions]

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 to
DashboardA. 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:

Show Suggested Answer Hide Answer
Suggested Answer:
by Manikom at Sept. 8, 2022, 8:05 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
RickyAnd
Highly Voted 2 years, 7 months ago
"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
upvoted 103 times
9f73003
1 year ago
This is incorrect, there is no option for XLSX files to create a tile in pbi service! 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
upvoted 26 times
rcaliandro
8 months, 1 week ago
I agree good answer and good link. But can you guys explain me why we need to convert the data in Excel as a table? Once we loaded the file, when we pin from Excel to a dashboard we don't select already the range and in this case we select the data range rather than the table?
upvoted 1 times
...
Mo2011
11 months ago
Correct, tested
upvoted 2 times
...
JudT
1 year ago
Correct and great link! Cheers
upvoted 1 times
...
...
Nemesizz
1 year, 11 months ago
I thought import creates a dataset and upload is used for automatically update?
upvoted 1 times
9f73003
1 year ago
I don't even see import as an option. I see in power bi service, in the workspace, the option to upload an xlsx file. NOTE: The file must be in Sharepoint or OneDrive, although the option to upload from your PC is there, this no longer works!! Wow. Details.
upvoted 2 times
...
...
Time2excel
1 year, 9 months ago
Spot on.
upvoted 1 times
...
AzureJobsTillRetire
2 years, 5 months ago
How can you add a tile for a dataset to dashboard? I'm not saying that you cannot do it for sure, but I have no idea how I can do it at the moment
upvoted 1 times
yahsee33
2 years, 4 months ago
Yeah I don't think there's any way to add a tile from a dataset directly
upvoted 1 times
jsking
2 years, 3 months ago
You can create tiles from a report, dataset, dashboard, the Q&A question box, Excel, SQL Server Reporting Services (SSRS), and more. Please read the documentation: https://learn.microsoft.com/en-us/power-bi/consumer/end-user-tiles
upvoted 3 times
9f73003
1 year ago
No, this link is better and within context: https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel
upvoted 1 times
...
...
...
...
Load full discussion...
...
PinkZebra
Highly Voted 2 years, 6 months ago
1. From Power BI, Upload Excel 2. Format Table 3. Pin Instruction video from Microsoft Youtube Channel: https://www.youtube.com/watch?v=l8JoB7w0zJA
upvoted 37 times
taod
1 year, 7 months ago
I tried it and pinning the data works. The problem ist the Q&A part that is specifically mentioned in the question. I didn't manage to activate Q&A by treating the file as a simple excel. Only by uploading it as a dataset, Q&A was possible!
upvoted 6 times
...
anasben
2 years, 3 months ago
Agree with PinkZebra
upvoted 2 times
...
iccent2
2 years, 4 months ago
This video was very helpful
upvoted 1 times
...
yahsee33
2 years, 4 months ago
that video does NOT show formatting as a table (which you cannot do in powerbi service, it just shows pinning a range)
upvoted 8 times
ApacheKafka
1 year, 8 months ago
You didn't watch the video then. What do you think was selecting the table and what he was saying while doing that? I under english is not everyones language but common.
upvoted 1 times
...
...
Load full discussion...
...
_jay95_
Most Recent 3 months, 1 week ago
1. From PowerBI.com, Upload Excel1 2. From Excel, create a named range (Table, PivotTables, PivotCharts, etc.,) 3. Pin a range from excel1 to dashbaordA
upvoted 1 times
...
jaume
5 months, 1 week ago
I would agree with proposed solution. First we need to upload the excel file to PBI service. I think Q&A cannot be enabled with DirectQuery so data must be imported into the datamodel so we are importing this uploaded data as dataset (no need to create a report to get tiles into a dashboard) Finally add a tie from the excel data to Dashboard. Cannot think in a reason to require data to be formatted as a table
upvoted 1 times
...
2c26c8e
9 months, 1 week ago
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..
upvoted 1 times
...
9f73003
1 year ago
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
upvoted 7 times
9f73003
1 year ago
I do not think formatting the Excel1 as a table is necessary here, but they want 3 steps....
upvoted 2 times
...
...
LorryTheTruck
1 year ago
The option "Format the data as a table" should be: "Save the data as a table"
upvoted 1 times
...
MeHungarian
1 year ago
2-3-4 correct answer
upvoted 1 times
...
Vras
1 year, 2 months ago
1. format the data as a table 2. Import as a dataset 3. add a tile for the dataset to dashboard
upvoted 2 times
...
MoxieTT
1 year, 11 months ago
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
upvoted 14 times
Vras
1 year, 2 months ago
Exactly!
upvoted 1 times
...
...
UlyUkr
1 year, 11 months ago
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.
upvoted 9 times
...
albertcal
1 year, 11 months ago
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
upvoted 4 times
...
Shalaleh
1 year, 11 months ago
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.
upvoted 4 times
...
Vadimasss1234
2 years, 3 months ago
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.
upvoted 1 times
Vadimasss1234
2 years, 3 months ago
But I can say for sure that before uploading an excel file, data should be formatted as a table, otherwise PBI doesn't allow to upload it.
upvoted 1 times
...
...
FamousExam64
2 years, 4 months ago
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
upvoted 10 times
...
slash_nyk
2 years, 4 months ago
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
upvoted 2 times
...
lukelin08
2 years, 4 months ago
1. Format Table 2. From Power BI, Upload Excel 3. Pin
upvoted 8 times
Shalaleh
2 years ago
I agree with this answer
upvoted 1 times
...
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago