Question
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.
- A. Excel Workbook
- B. Text/CSV
- C. Folder
- D. SharePoint folder Correct
- E. Web Correct
Explanation
OneDrive for work or school is built on SharePoint Online, so the SharePoint folder connector can reach the file through the cloud and the dataset refreshes in the service without a gateway. The Web connector with the file's OneDrive URL also connects to the cloud copy and supports scheduled refresh. The Excel Workbook and Folder connectors point at a local or synced file path, which the service cannot reach without a gateway, and Text/CSV cannot read an Excel file.
