exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 1 question 11 discussion

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

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

  • A. Excel Workbook
  • B. Text/CSV
  • C. Folder
  • D. SharePoint folder
  • E. Web
Show Suggested Answer Hide Answer
Suggested Answer: DE 🗳️

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
Fer079
Highly Voted 2 years, 5 months ago
Selected Answer: DE
We can import an excel file from multiple connectors (excel workbook, folder, web, sharepoint) but if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors
upvoted 88 times
gstep
2 months ago
A, D and E are valid answers, which two are tem more accurate?
upvoted 1 times
...
9f73003
11 months ago
It would depend if there is authentication involved with the SharePoint folder or the Web address, what if they are using basic auth? Anyway, either of the answers, a,b,c,d all offer difficulty for me to answer as the correct one. So, I guess it is which is the most correct?
upvoted 2 times
...
Shalaleh
1 year, 10 months ago
but OneDrive is cloud and we do not need a gateway.
upvoted 4 times
...
NevilleV
2 years, 5 months ago
Try it. D and E won't work. Its looking for a URL
upvoted 2 times
Fer079
2 years, 5 months ago
I tried both and they work perfectly, and of course, you need the path (in this case the URL of the excel file on One Drive) of the file, so I don´t see the problem you say...
upvoted 18 times
...
KobeData
2 years, 4 months ago
Works just fine, this is how you do it :)
upvoted 15 times
GuerreiroJunior
2 years, 2 months ago
Agreed KobeData
upvoted 5 times
...
...
...
...
fred92
Highly Voted 2 years, 5 months ago
Selected Answer: DE
A, B, C: wrong! Would work technically, but the connection will be only to the local copy of the file, no refresh from the online version stored on OneDrive D: correct, but more complicated than option E E: correct, this is the best option to import from OneDrive
upvoted 37 times
...
Kbo05
Most Recent 2 days, 21 hours ago
Selected Answer: AB
Excel/Workbook, Text/CSV
upvoted 1 times
...
NgocPham
1 month, 1 week ago
Selected Answer: DE
For people who are using chat GPT, if you ask another question: which connectors allow refresh from powerbi.com, it will show you that if the file is on OneDrive, we should connect it via SharePoint, not a direct support. It answered A because it is a possibility and GPT does not always consider all the logic.
upvoted 1 times
...
Ajani161
1 month, 1 week ago
Selected Answer: AE
It doesn’t say Sharepoint folder. It explicitly says OneDrive.
upvoted 1 times
...
b2775a4
1 month, 2 weeks ago
Selected Answer: AD
Correct Answers: A. Excel Workbook: This is a direct and commonly used connector for importing Excel files into Power BI. It supports OneDrive integration and allows scheduled refreshes on powerbi.com. D. SharePoint Folder: If the file is stored in a OneDrive folder, which is backed by SharePoint in the backend, the "SharePoint Folder" connector can be used to access it. This method is also refreshable. Explanation of Other Options: B. Text/CSV: Not applicable for Excel files unless the file is exported as a .csv. Even then, it won't support refresh like the Excel connector. C. Folder: Used for combining files in a folder but not specifically for accessing a single Excel file in OneDrive. E. Web: Can be used if the file is accessible via a web URL (e.g., a public link), but this is not optimal or commonly used for OneDrive-stored files.
upvoted 3 times
...
Fatima300
1 month, 2 weeks ago
Selected Answer: AD
Since the Excel file is stored in a OneDrive folder, you need a connector that allows cloud-based access and scheduled refresh in Power BI Service. ✅ A. Excel Workbook (Correct) This is the most direct and recommended way to connect to an Excel file stored in OneDrive. It allows scheduled refresh in Power BI Service. ✅ D. SharePoint Folder (Correct) OneDrive for Business is built on SharePoint, so the SharePoint Folder connector can also be used. This is useful if you need to access multiple files in a OneDrive folder at once. It supports scheduled refresh in Power BI Service.
upvoted 2 times
...
Odidepse
2 months, 1 week ago
Selected Answer: AE
I tested this and answer is confirmed A and E. Question is what connectors, Excel workbook is a clear choice as stated on the question "Microsoft Excel file in a Microsoft OneDrive folder" when you select the 'excel workbook' connector, it grabs the file from one Drive. And E is the other clear answer (Web) connector, on the excel file , go to file>Info>copy path. Use the path and paste it on the URL section and I was able to retrieve and do a refresh. Nothing on the question that states excel is stored on a sharepoint folder so it is A and E for me.
upvoted 1 times
...
mdnaseershah
2 months, 3 weeks ago
Selected Answer: AD
Tried Option A and it works. When you have OneDrive syncing on your machine then this option is simple and Straight forward. D: Onedrive for business is built on SharePoint Online, hence you can access Ondrive files from SharePoint folder connector
upvoted 2 times
...
jaume
4 months ago
I would vote for A and D options. Excel connector looks like requiring local gateway and web option in Semantic Model (former Dataset) I just tried is offering "Web API" and "Web Page" available options which doesn't look correct to me
upvoted 1 times
...
SanaCanada
5 months, 2 weeks ago
Selected Answer: AD
Correct Answer A and D A. Excel Workbook D. SharePoint folder You can use the "Excel Workbook" connector to connect to the Excel file stored in OneDrive and import it into a Power BI dataset. This connector allows you to select the OneDrive folder where the file is located and specify the file name. You can also use the "SharePoint folder" connector to connect to the OneDrive folder and import the Excel file into a Power BI dataset. This connector allows you to specify the URL of the OneDrive folder and navigate to the Excel file within the folder. Using either of these connectors ensures that the dataset can be refreshed in Power BI, as the connection to the OneDrive folder will remain active even if the Excel file is updated or moved within the folder. No confusion, and no need to discuss further
upvoted 4 times
CandySays
1 year, 1 month ago
https://www.youtube.com/watch?v=CYSMZxaXNLk
upvoted 4 times
masto71
1 month, 2 weeks ago
The video is two years old, and it seems that Microsoft has resolved the issue since then. I tested it, and it worked in my case.
upvoted 1 times
...
...
...
SanaCanada
5 months, 2 weeks ago
Selected Answer: AD
Correct Ansers A. Excel Workbook D. SharePoint folder To ensure that the dataset can be refreshed in powerbi.com, you can use the Excel Workbook connector or the SharePoint folder connector to connect to the Excel file in Microsoft OneDrive. The Excel Workbook connector allows you to connect to an Excel file in OneDrive and create a Power BI dataset directly from the file. This connector also enables you to schedule automatic refreshes of the dataset to ensure that the data is always up-to-date. The SharePoint folder connector allows you to connect to a SharePoint folder where the Excel file is stored, and then you can select the Excel file to create a dataset. This connector also supports automatic refreshes of the dataset. Using either of these connectors will ensure that the dataset can be refreshed in powerbi.com, as long as the OneDrive file is accessible and the credentials used to connect to the file are valid. No confusion, and no need to discuss further
upvoted 4 times
...
T_bone
5 months, 3 weeks ago
I believe A & C are the right answers. I have my excel file in Onedrive and I connect to the dataset through this means and refresh my dashboards. We can import excel files directly from Onedrive which is cloud. gateway connection isnt needed.
upvoted 1 times
...
nammm112
6 months, 1 week ago
Selected Answer: DE
schedule refresh without a gateway
upvoted 1 times
...
Mustafa__
6 months, 4 weeks ago
Answer: A. Excel Workbook and D. SharePoint folder Reason: Excel Workbook (A): Directly connects to an Excel file stored in OneDrive. Power BI supports this connection type, and the dataset can be refreshed in Power BI service. SharePoint folder (D): Connects to files stored in SharePoint, which includes OneDrive for Business. This allows Power BI to access and refresh the Excel file as long as it's in a SharePoint or OneDrive for Business folder. Text/CSV (B): Used for CSV files, not Excel files. Folder (C): Used for multiple files in a folder, not specifically for a single Excel file. Web (E): Used for web URLs, not for files stored in OneDrive.
upvoted 1 times
asdren88
6 months ago
that is how I understood it as well. As mentioned we have an Excel file in one drive. So we would first connect with the SharePoint folder, and then get the Excel from that folder.
upvoted 1 times
...
...
rcaliandro
7 months ago
Selected Answer: DE
You need to ensure that the dataset can be refreshed in powerbi.com
upvoted 1 times
...
niceguysfinishlast
7 months, 4 weeks ago
a and c are correct. it requires physical copies to be imported into the power bi dataset and not some data gateway as in the case of web and sharepoint.
upvoted 1 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago