Which two connectors can you use to connect to the file?

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 powefbi.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 . Text/CSV
B. Folder
C. Excel Workbook
D. SharePoint folder
E. Web

View Answer

Answer: D,E

Explanation:

– Copy and edit Path of the Excel file then use "Web" Connector: Option E

– Copy and edit Path of the OneDrive folder then use "Sharepoint Folder" connector: Option D

Source: https://www.youtube.com/watch?v=GGHbbg6yi-A