PL-300 · Question #218
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…
The correct answer is D. SharePoint folder E. Web. We can import an excel file from multiple connectors (excel workbook, folder, web, sharepoint) but if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors…
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 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.
Options
- AText/CSV
- BFolder
- CExcel Workbook
- DSharePoint folder
- EWeb
How the community answered
(37 responses)- A8% (3)
- B3% (1)
- C16% (6)
- D73% (27)
Explanation
We can import an excel file from multiple connectors (excel workbook, folder, web, sharepoint) but if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Topics
Community Discussion
No community discussion yet for this question.