Learn the two connectors in Power BI that allow importing an Excel file from OneDrive and enable refreshing the semantic model on PowerBI.com. Prepare for Microsoft PL-300 exam.
Table of Contents
Question
You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI semantic model.
You need to ensure that the semantic model 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. Web
B. Excel Workbook
C. Folder
D. Text/CSV
E. SharePoint folder
Answer
To import an Excel file from Microsoft OneDrive into a Power BI semantic model and ensure the model can be refreshed on PowerBI.com, you can use the following two connectors:
B. Excel Workbook
E. SharePoint folder
Explanation
The Excel Workbook connector allows you to import data from an Excel file into Power BI. When the Excel file is stored in OneDrive, you can connect to it using this connector. It supports refreshing the data in the Power BI service (PowerBI.com).
The SharePoint folder connector lets you import files from a SharePoint folder, including Excel files. Since OneDrive is built on SharePoint technology, you can use this connector to access Excel files stored in OneDrive. The connector supports data refresh in PowerBI.com.
The other connectors mentioned are not suitable for this scenario:
- Web connector is used for importing data from web pages, not Excel files.
- Folder connector is for accessing files in a local directory or shared folder, not cloud storage like OneDrive.
- Text/CSV connector imports data from text files, not Excel workbooks.
Therefore, using either the Excel Workbook or SharePoint folder connector will allow importing the Excel file from OneDrive and enable refreshing the semantic model on PowerBI.com.
Microsoft PL-300 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Microsoft PL-300 exam and earn Microsoft PL-300 certification.