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?
Web is correct. The Web connector can connect to the file via its URL and supports refresh in the Power BI service.
SharePoint folder is correct. The SharePoint folder connector can access files in OneDrive and supports scheduled refresh in powerbi.com.
Text/CSV is incorrect. The Text/CSV connector is not applicable for Excel files.
Folder is incorrect. The Folder connector does not support refresh in the Power BI service for OneDrive locations.
Excel Workbook is incorrect. The Excel Workbook connector does not support refresh in the Power BI service for files stored in OneDrive.