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? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
AC
A: Connect to an Excel workbook from Power Query Desktop
To make the connection from Power Query Desktop:
1. Select the Excel option in the connector selection.
2. Browse for and select the Excel workbook you want to load. Then select Open.
3. Etc.
C: Folder connector capabilities supported
Folder path -
Combine -
Combine and load -
Combine and transform -
Connect to a folder from Power Query Online
To connect to a folder from Power Query Online:
1. Select the Folder option in the connector selection.
2. Enter the path to the folder you want to load.
Note:
Reference:
https://docs.microsoft.com/en-us/power-query/connectors/excel https://docs.microsoft.com/en-us/power-query/connectors/folder
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
Try it. D and E won't work. Its looking for a URL
I tried both and they work perfectly, and of course, you need the path (in this case the URL of the excel file on One Drive) of the file, so I don´t see the problem you say...
Works just fine, this is how you do it :) https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
This page explains both the Web and the SharePoint option: https://learn.microsoft.com/en-us/power-query/sharepoint-onedrive-files
Agreed KobeData
but OneDrive is cloud and we do not need a gateway.
It would depend if there is authentication involved with the SharePoint folder or the Web address, what if they are using basic auth? Anyway, either of the answers, a,b,c,d all offer difficulty for me to answer as the correct one. So, I guess it is which is the most correct?
A, B, C: wrong! Would work technically, but the connection will be only to the local copy of the file, no refresh from the online version stored on OneDrive D: correct, but more complicated than option E E: correct, this is the best option to import from OneDrive
This was in the exam today. I passed the exam with 911 score. My answer : SharePoint Folder and Web
- The biggest difference between AC and DE is about authentication. With AC you already have the OneDrive folder synced to your computer, so once the dataset is published into the Power BI service, no further configuration needs to be made (assume that gateway was installed on your computer). - On top of that all 4 option is possible, but AC requires the least operation. Since the question does not mention anything about authentication, AC should be the most suitable
The requirement is "You need to ensure that the dataset can be refreshed in powerbi.com". No assumption on what you need to configure so that the dataset is updated. If you're connected through the Web or SharePoint Location, the ability to refresh from Power BI is already available with no additional connection configuration.
"The file must be imported to a Power BI dataset." that may be the key of this question, as the 4 options can connect to the online file, if want this file can be imported to a Power BI dataset, Sharepoint folder and Web will have some limitations, but Excel Workbook and Folder can definitely be imported to this Power BI dataset. Excel Workbook and Folder related documents: Connect to a folder from Power Query Online: https://learn.microsoft.com/en-us/power-query/connectors/folder#connect-to-a-folder-from-power-query-online Connect to an Excel workbook from Power Query Online: https://learn.microsoft.com/en-us/power-query/connectors/excel#connect-to-an-excel-workbook-from-power-query-online
option D&E - The SharePoint folder connector also work for files hosted on OneDrive for Business.
thnx was looking for this :)
This was on the exam on 22/2/2024 (:
A & C connectors present you the common dialog window allowing you to pickup the file from your ONE DRIVE FOLDER(available from windows explorer). No credentials needed, no extra authentication
The correct answer is E - Web https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
2 answers brah
THIS WAS ON THE EXAM 02/03/2024
Did you pass the exam? What study resources did you use?
a and c are correct. it requires physical copies to be imported into the power bi dataset and not some data gateway as in the case of web and sharepoint.
The correct Answer that i am very sure of is E, i always connect my google sheet file to power BI using web option and it always get refreshed on schedule refresh
Tested.
Since the File is in excel format and residing in cloud (OneDrive), we can connect to it easily either by SharePoint or Web Connecters.
Chatgpt says the answer is sharepointfolder and web and I agree
ChatGPT is wrong A TON!!! Be very careful with that thing.
28-Mar-24 - This Q came up. Blitzed all 266 Q's on Exam Topics and Scored 813/1000. Only 1 question out of the 50 wasn't on exam topics exactly.
salut , combien de questions dans l'exemen et la durée svp
Chatgpt: Excelworkbook and Web
Chatgpt is not always right.
ChatGPT is wrong a ton and DANGEROUS! Seriously. People need to do their homework and recognize ChatGPT for the entertainment piece that it is, and that is all it is.
GPT probably found its answer from this site, unfortunately