PL-300 Question #394: Real Exam Question with Answer & Explanation

Question

You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI semantic model. You need to ensure that the semantic model can be refreshed in PowerBi.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

• AWeb
• BExcel Workbook
• CFolder
• DText/CSV
• ESharePoint folder

Explanation

To ensure a Power BI semantic model can refresh an Excel file from OneDrive in PowerBi.com, you should use the Web connector with a direct URL or the SharePoint folder connector.

Common mistakes.

• B. The standard Excel Workbook connector is primarily designed for local files and typically requires a Power BI On-premises data gateway for refresh if the file is on a local network drive, which is not applicable for cloud-hosted OneDrive.
• C. The Folder connector is primarily used for local or network file system folders and would require an On-premises data gateway to refresh files in the Power BI service, which is not suitable for a cloud-hosted OneDrive file.
• D. The Text/CSV connector is specifically for text or CSV files, not for Excel workbooks.

Concept tested. Power BI cloud refresh for OneDrive/SharePoint files

Reference. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links

No community discussion yet for this question.