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

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:

    Correct 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

Discussion
RickyAnd

"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

AzureJobsTillRetire

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

yahsee33

Yeah I don't think there's any way to add a tile from a dataset directly

jsking

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

9f73003

No, this link is better and within context: https://learn.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-tile-from-excel

Nemesizz

I thought import creates a dataset and upload is used for automatically update?

9f73003

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.

Time2excel

Spot on.

9f73003

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

JudT

Correct and great link! Cheers

Mo2011

Correct, tested

PinkZebra

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

iccent2

This video was very helpful

yahsee33

that video does NOT show formatting as a table (which you cannot do in powerbi service, it just shows pinning a range)

ApacheKafka

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.

anasben

Agree with PinkZebra

taod

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!

MoxieTT

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

Vras

Exactly!

FamousExam64

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

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

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

Shalaleh

I agree with this answer

UlyUkr

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.

poujor

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

albertcal

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

Shalaleh

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.

9f73003

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

9f73003

I do not think formatting the Excel1 as a table is necessary here, but they want 3 steps....

Vras

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

slash_nyk

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

2c26c8e

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..

LorryTheTruck

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

MeHungarian

2-3-4 correct answer

Vadimasss1234

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.

Vadimasss1234

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.