Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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:
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
by Manikom at Sept. 8, 2022, 8:05 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
RickyAnd
Highly Voted 2 years, 2 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 98 times
9f73003
7 months, 1 week 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 22 times
rcaliandro
3 months 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
6 months ago
Correct, tested
upvoted 1 times
...
JudT
7 months, 1 week ago
Correct and great link! Cheers
upvoted 1 times
...
...
Nemesizz
1 year, 6 months ago
I thought import creates a dataset and upload is used for automatically update?
upvoted 1 times
9f73003
7 months, 1 week 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, 4 months ago
Spot on.
upvoted 1 times
...
AzureJobsTillRetire
1 year, 12 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
1 year, 11 months ago
Yeah I don't think there's any way to add a tile from a dataset directly
upvoted 1 times
jsking
1 year, 11 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
7 months, 1 week 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, 1 month 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 36 times
taod
1 year, 2 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
1 year, 10 months ago
Agree with PinkZebra
upvoted 2 times
...
iccent2
1 year, 11 months ago
This video was very helpful
upvoted 1 times
...
yahsee33
1 year, 11 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, 3 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...
...
jaume
Most Recent 4 days, 16 hours 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
4 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
7 months, 1 week 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 6 times
9f73003
7 months, 1 week ago
I do not think formatting the Excel1 as a table is necessary here, but they want 3 steps....
upvoted 2 times
...
...
LorryTheTruck
7 months, 2 weeks ago
The option "Format the data as a table" should be: "Save the data as a table"
upvoted 1 times
...
MeHungarian
7 months, 2 weeks ago
2-3-4 correct answer
upvoted 1 times
...
Vras
9 months, 1 week 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, 6 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
9 months, 1 week ago
Exactly!
upvoted 1 times
...
...
UlyUkr
1 year, 6 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, 6 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, 6 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
1 year, 10 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
1 year, 10 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
1 year, 11 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
1 year, 11 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
1 year, 12 months ago
1. Format Table 2. From Power BI, Upload Excel 3. Pin
upvoted 8 times
Shalaleh
1 year, 7 months ago
I agree with this answer
upvoted 1 times
...
...
evipap
2 years ago
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/
upvoted 9 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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