Mark, the CTO of MDFT Pro, has asked you to set up a refreshable Power BI dataset for the education team. 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?
SharePoint folder is correct. The SharePoint folder connector can access files in OneDrive and supports scheduled refresh in powerbi.com.
Folder is incorrect. The Folder connector does not support refresh in the Power BI service for OneDrive locations.
Text/CSV is incorrect. The Text/CSV connector is not applicable for Excel files.
Web is incorrect. The Web connector is not the standard method for connecting to OneDrive Excel files and would require complex authentication configuration; it is not recommended for this scenario.
Excel Workbook is correct. The Excel Workbook connector supports refresh in the Power BI service when connecting to files stored in OneDrive or SharePoint, making it a valid choice.