Exam PL-300 topic 1 question 40 discussion

For me is AE

A and E are the correct answers. Just tested it now end to end and it works. Refreshing is performed as well. For B/C to be refreshed online, you'd need a Gateway which is not mentioned here.

A y E. EL enunciado da por entendido que es una actualizacion automatica y sin puesta de enlace...

Correct Answers: A. Web: When the Excel file is stored in a OneDrive folder, you can use the Web connector with the file's URL link. This allows Power BI to access the file directly from OneDrive, and the dataset can be refreshed in PowerBI.com as long as the URL points to the latest file. E. SharePoint Folder: Since OneDrive is backed by SharePoint, you can use the SharePoint Folder connector to access the file. The SharePoint connector ensures that the file is accessible and refreshable in Power BI. Why Not the Other Options? B. Excel Workbook: While this connector works for local Excel files, it does not guarantee refreshability when the file is stored in OneDrive. C. Folder: This connector is used to combine data from multiple files in a folder, but it is not specifically designed for OneDrive or SharePoint. D. Text/CSV: This connector is used for text or CSV files, not for Excel files.

Tested this myself, A is the first obvious answer, you use the 'Excel Workbook' connector and it will grab to a one drive folder as stated on the question Microsoft Excel file in a Microsoft OneDrive folder. The other one is a definite web, as the excel file is on the one drive path and nothing is mentioned on the sharepoint folder, these are the steps that I took: Navigate the excel file stored on one drive, go to file, copy path. Then go to powerbi desktop app, get datasource, use 'web' connector and on the URL section, paste the path. SharePoint folder required root url of the sharepoint, nothing on the question outlines that the excel document is stored on sharepoint.

B. Excel Workbook and E. SharePoint Folder are the correct connectors because both are optimized for accessing files stored in OneDrive for Business, and they support scheduled refreshes in Power BI Service (PowerBi.com), ensuring your data stays up-to-date without manual intervention.

BE It is not A because the web connector is used to retrieve data from the web not access files.

A & E, Otherwise you'll need to implement a data gateway (for onpremise data sources)

excel fil - so B / E both feasible options.

To ensure that the semantic model can be refreshed in Power BI service (PowerBI.com), you can use the following two connectors: B. Excel Workbook: This connector allows you to directly import data from an Excel file stored in OneDrive, ensuring that the data can be refreshed in Power BI service. E. SharePoint folder: If your OneDrive is linked to SharePoint, this connector can be used to access and refresh the Excel file in Power BI service. These connectors support automatic refresh capabilities, making them suitable for your requirements.

Excel Workbook (Option B): You can connect to an Excel file stored on OneDrive using the Excel Workbook connector. This connector will allow Power BI to connect to the Excel file, and the model can be refreshed in Power BI Service (PowerBI.com) as long as the file is stored on OneDrive and is properly linked. When you use OneDrive, Power BI can automatically refresh the data in the report from the Excel file, and it will be kept in sync with the source. SharePoint Folder (Option E): A SharePoint folder connector can also be used to access files stored in a SharePoint Online document library, which includes OneDrive for Business files. By using the SharePoint folder connector, you can easily import the Excel file from OneDrive, and the Power BI model can be refreshed in PowerBI.com, similar to the Excel Workbook option.

I've connected several times to excel files to get data into PBI and, while hosted in a OneDrive folder, everything refresh fine connecting directly to the file using "Excel Workbook" connector and using "Sharepoint folder" connector. Never used the "Web" connector to get data from an excel file. Gateway should be set for the option C in case that folder would be in a local network but I don't think it's needed connecting to an excel file hosted in a OneDrive folder

AE in my opinion