Microsoft Power BI Data Analyst — Question 116

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.

Answer options

• A. Web
• B. Excel Workbook
• C. Folder
• D. Text/CSV
• E. SharePoint folder

Correct answer: A, E

Explanation

The correct answers are A (Web) and E (SharePoint folder) because both connectors can access files stored in OneDrive and support refresh capabilities in Power BI. The other options like B (Excel Workbook), C (Folder), and D (Text/CSV) do not provide the necessary refresh functionality in the Power BI service for files located in OneDrive.