Connectors for OneDrive Excel Refresh in Power BI
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.
Answer
Correct answer: D, E — Use the SharePoint folder and Web connectors to import the OneDrive Excel file for seamless service refresh.
Community Votes
63% of anonymous learners picked answer DE. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The exam tests the distinction between local/file-based connectors and cloud-native connectors that support service-side refresh.
This question tests the correct connectors for importing an Excel file from OneDrive to ensure scheduled refresh in the Power BI Service. The Web and SharePoint Folder connectors are required because they support cloud-based data sources without on-premises gateways.
Learners often select 'Excel Workbook' or 'Text/CSV', which are valid for desktop but require a gateway for service refresh when pointing to local paths, or fail to recognize that OneDrive is accessed via SharePoint protocols.
Community Discussion (118 comments)
saarah9
👍 1
Selected: AD
Excel File in OneDrive and must be imported into Power BI semantic model and onedrive is backed by sharepoint online path so Powerbi automatically can connect .
Marlon FR
👍 1
Selected: AD
Para un archivo guardado en OneDrive que requiere actualización programada en powerbi.com (Power BI Service) sin necesidad de instalar una puerta de enlace (Personal Gateway local), las dos formas admitidas son: A. Libro de trabajo de Excel (Excel Workbook): Permite conectarse directamente al archivo de Excel almacenado en OneDrive para la Empresa / Personal. Al conectarse usando las credenciales de la cuenta organizacional de Microsoft, Power BI Service puede realizar la actualización programada automáticamente en la nube. D. Carpeta de SharePoint (SharePoint Folder): OneDrive para la Empresa está estructurado internamente sobre la infraestructura de SharePoint Online. Utilizar el conector de Carpeta de SharePoint apunta a la biblioteca de documentos en la nube, lo que permite el acceso directo y la actualización automatizada en powerbi.com.
aisyah_1208
👍 1
Selected: AD
Key requirement here is Excel File in OneDrive > must be imported into Power BI semantic model > support refresh in Power BI Service A. Excel - When you import files from OneDrive or SharePoint Online, it ensures the work you’re doing in Excel stays in sync with the Power BI service. Any data that you’ve loaded into your file’s model then updates in the semantic model.
saarah9
👍 2
Selected: AD
Excel workbook can connect directly to an excel file in onedrive powerbi, and onedrive is backed by sharepoint online path so Powerbi automatically can connect .
HeyJitu_25
👍 2
Selected: AD
✅ A. Excel Workbook ✔ ✅ D. SharePoint Folder ✔ The Excel Workbook connector can connect directly to an Excel file stored in OneDrive. Power BI Service can refresh it because OneDrive is a supported cloud storage. OneDrive for Business is built on SharePoint Online. Behind the scenes, your OneDrive files are stored in SharePoint. Therefore, you can use the SharePoint Folder connector to access Excel files stored in OneDrive and schedule refresh in the Power BI Service.
omath
👍 2
Selected: AE
Answers: - A. Excel Workbook Correct when you use the OneDrive for Business or SharePoint Online path. Power BI automatically keeps the connection cloud-based and supports refresh. - D. SharePoint folder OneDrive for Business is backed by SharePoint Online. Using the SharePoint folder connector is a supported and recommended method for scheduled refresh. Why not the others: - B. Text/CSV Only applies if the file is a CSV, but the question says it’s an Excel file. - C. Folder Refers to a local or network folder. Would require a gateway and is not ideal for OneDrive refresh. - E. Web While technically possible with a direct download link, it’s not the recommended or simplest approach for OneDrive integration in enterprise scenarios.
SwaH119
👍 1
Selected: DE
D& E should be the answer
Lulu_2022
👍 5
Selected: DE
D. SharePoint Folder OneDrive for Business is built on SharePoint Online. Using the SharePoint Folder connector allows Power BI to access all files in a document library. You can then filter by file name or folder path to isolate your Excel file. This method supports scheduled refresh in the Power BI Service. E. Web You can use the Web connector with a direct link to the Excel file stored in OneDrive. Make sure to clean the URL (remove ?web=1) and authenticate using Organizational Account. This also supports refresh in powerbi.com, as long as you use OAuth2 authentication3.
BP215
👍 1
Selected: DE
DE is the right answer
Kbo05
👍 1
Selected: AB
Excel/Workbook, Text/CSV
NgocPham
👍 1
Selected: DE
For people who are using chat GPT, if you ask another question: which connectors allow refresh from powerbi.com, it will show you that if the file is on OneDrive, we should connect it via SharePoint, not a direct support. It answered A because it is a possibility and GPT does not always consider all the logic.
Ajani161
👍 3
Selected: AE
It doesn’t say Sharepoint folder. It explicitly says OneDrive.
944e7a1
👍 1
OneDrive is SharePoint, look at a personal OneDrive link, it connects to SharePoint.
b2775a4
👍 5
Selected: AD
Correct Answers: A. Excel Workbook: This is a direct and commonly used connector for importing Excel files into Power BI. It supports OneDrive integration and allows scheduled refreshes on powerbi.com. D. SharePoint Folder: If the file is stored in a OneDrive folder, which is backed by SharePoint in the backend, the "SharePoint Folder" connector can be used to access it. This method is also refreshable. Explanation of Other Options: B. Text/CSV: Not applicable for Excel files unless the file is exported as a .csv. Even then, it won't support refresh like the Excel connector. C. Folder: Used for combining files in a folder but not specifically for accessing a single Excel file in OneDrive. E. Web: Can be used if the file is accessible via a web URL (e.g., a public link), but this is not optimal or commonly used for OneDrive-stored files.
Fatima300
👍 2
Selected: AD
Since the Excel file is stored in a OneDrive folder, you need a connector that allows cloud-based access and scheduled refresh in Power BI Service. ✅ A. Excel Workbook (Correct) This is the most direct and recommended way to connect to an Excel file stored in OneDrive. It allows scheduled refresh in Power BI Service. ✅ D. SharePoint Folder (Correct) OneDrive for Business is built on SharePoint, so the SharePoint Folder connector can also be used. This is useful if you need to access multiple files in a OneDrive folder at once. It supports scheduled refresh in Power BI Service.
Odidepse
👍 1
Selected: AE
I tested this and answer is confirmed A and E. Question is what connectors, Excel workbook is a clear choice as stated on the question "Microsoft Excel file in a Microsoft OneDrive folder" when you select the 'excel workbook' connector, it grabs the file from one Drive. And E is the other clear answer (Web) connector, on the excel file , go to file>Info>copy path. Use the path and paste it on the URL section and I was able to retrieve and do a refresh. Nothing on the question that states excel is stored on a sharepoint folder so it is A and E for me.
mdnaseershah
👍 2
Selected: AD
Tried Option A and it works. When you have OneDrive syncing on your machine then this option is simple and Straight forward. D: Onedrive for business is built on SharePoint Online, hence you can access Ondrive files from SharePoint folder connector
jaume
👍 1
I would vote for A and D options. Excel connector looks like requiring local gateway and web option in Semantic Model (former Dataset) I just tried is offering "Web API" and "Web Page" available options which doesn't look correct to me
SanaCanada
👍 4
Selected: AD
Correct Answer A and D A. Excel Workbook D. SharePoint folder You can use the "Excel Workbook" connector to connect to the Excel file stored in OneDrive and import it into a Power BI dataset. This connector allows you to select the OneDrive folder where the file is located and specify the file name. You can also use the "SharePoint folder" connector to connect to the OneDrive folder and import the Excel file into a Power BI dataset. This connector allows you to specify the URL of the OneDrive folder and navigate to the Excel file within the folder. Using either of these connectors ensures that the dataset can be refreshed in Power BI, as the connection to the OneDrive folder will remain active even if the Excel file is updated or moved within the folder. No confusion, and no need to discuss further
CandySays
👍 5
https://www.youtube.com/watch?v=CYSMZxaXNLk
masto71
👍 1
The video is two years old, and it seems that Microsoft has resolved the issue since then. I tested it, and it worked in my case.
SanaCanada
👍 4
Selected: AD
Correct Ansers A. Excel Workbook D. SharePoint folder To ensure that the dataset can be refreshed in powerbi.com, you can use the Excel Workbook connector or the SharePoint folder connector to connect to the Excel file in Microsoft OneDrive. The Excel Workbook connector allows you to connect to an Excel file in OneDrive and create a Power BI dataset directly from the file. This connector also enables you to schedule automatic refreshes of the dataset to ensure that the data is always up-to-date. The SharePoint folder connector allows you to connect to a SharePoint folder where the Excel file is stored, and then you can select the Excel file to create a dataset. This connector also supports automatic refreshes of the dataset. Using either of these connectors will ensure that the dataset can be refreshed in powerbi.com, as long as the OneDrive file is accessible and the credentials used to connect to the file are valid. No confusion, and no need to discuss further
T_bone
👍 1
I believe A & C are the right answers. I have my excel file in Onedrive and I connect to the dataset through this means and refresh my dashboards. We can import excel files directly from Onedrive which is cloud. gateway connection isnt needed.
nammm112
👍 1
Selected: DE
schedule refresh without a gateway
Mustafa__
👍 1
Answer: A. Excel Workbook and D. SharePoint folder Reason: Excel Workbook (A): Directly connects to an Excel file stored in OneDrive. Power BI supports this connection type, and the dataset can be refreshed in Power BI service. SharePoint folder (D): Connects to files stored in SharePoint, which includes OneDrive for Business. This allows Power BI to access and refresh the Excel file as long as it's in a SharePoint or OneDrive for Business folder. Text/CSV (B): Used for CSV files, not Excel files. Folder (C): Used for multiple files in a folder, not specifically for a single Excel file. Web (E): Used for web URLs, not for files stored in OneDrive.
asdren88
👍 1
that is how I understood it as well. As mentioned we have an Excel file in one drive. So we would first connect with the SharePoint folder, and then get the Excel from that folder.
rcaliandro
👍 1
Selected: DE
You need to ensure that the dataset can be refreshed in powerbi.com
niceguysfinishlast
👍 1
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.
KipngenohVinnie
👍 1
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
HenryBiz
👍 1
Selected: DE
Tested.
CaptainSappy11
👍 1
Selected: DE
Since the File is in excel format and residing in cloud (OneDrive), we can connect to it easily either by SharePoint or Web Connecters.
emmanueladisa1
👍 1
Chatgpt says the answer is sharepointfolder and web and I agree
9f73003
👍 4
ChatGPT is wrong A TON!!! Be very careful with that thing.
Muying_Zhao
👍 5
Selected: AC
"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
Dani_eL
👍 5
Selected: AC
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
shs31
👍 4
option D&E - The SharePoint folder connector also work for files hosted on OneDrive for Business.
Uhoh
👍 1
thnx was looking for this :)
SumaiyaKS
👍 4
The correct answer is E - Web https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
HoanNguyenVNmese
👍 2
2 answers brah
9f73003
👍 1
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.
asnygen
👍 1
Chatgpt: Excelworkbook and Web
cs3122
👍 5
GPT probably found its answer from this site, unfortunately
bbshu0801
👍 5
Chatgpt is not always right.
Ryan_042
👍 5
Selected: AC
- 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
CookieMingkee
👍 5
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.
venupurna
👍 28
This was in the exam today. I passed the exam with 911 score. My answer : SharePoint Folder and Web
TrustMyAnswers
👍 1
D and E, because the data needs to be refreshed from PBI Service.
Kish1604
👍 3
Selected: DE
Connecting via SharePoint folder or Web does not require Gateway service
IrynaVilner
👍 1
My answer is A,C
sankeytm
👍 3
Selected: DE
Referred to - https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
Pratham8285
👍 5
Selected: DE
It's definitely DE as explained from Microsoft instructor
Igetmyrole
👍 2
A & D are the two connectors we use to connect to the file. That is because: A. Excel Workbook: Power BI supports direct connections to Excel files in OneDrive, allowing you to import data and refresh it in Power BI Service. D. SharePoint folder: OneDrive for Business is often integrated with SharePoint, and you can use the SharePoint folder connector to access files stored in a SharePoint document library, which can include OneDrive files.
Acrious
👍 2
Selected: DE
In the Excel connector you can see the docmentation says "If the Excel workbook is online, use the Web connector to connect to the workbook."
Bnxyl
👍 1
The answer is D and E. This is what stands out in the question "You need to ensure that the dataset can be refreshed in powerbi.com." You can sync your one drive with SharePoint folder and then for one drive, no gateway is needed so you can just use web for connecting
globalexamtopics
👍 1
ChatGPT4: According to the document, to connect to the Excel file in a Microsoft OneDrive folder for importing to a Power BI dataset, you can use the following two connectors: Excel Workbook (Option A): Power BI allows you to get data from many types of files, including Excel workbooks. You can select the Excel option when using the Get data feature in Power BI Desktop. SharePoint - Team Sites (Option D): Saving your Power BI Desktop files to SharePoint Team Sites is similar to saving to OneDrive for Business. The main difference is how you connect to the file from Power BI. You can specify a URL or connect to the root folder.
Maniula
👍 3
ChatGPT doesn't know the question, which is about Excel Workbook but on OneDrive, not on your computer. The answer is Web & Sharepoint (can by synced with OneDrive).
AlanTech
👍 1
From reading materials: According to the document, to connect to a Microsoft Excel file in a Microsoft OneDrive folder and ensure that the dataset can be refreshed in powerbi.com, you can use the following two connectors: Excel Workbook (Option A): Power BI allows you to get data from many types of files, including Excel workbooks. You can select the Excel option when using the Get Data feature in Power BI Desktop. SharePoint - Team Sites (Option D): Saving your Power BI Desktop files to SharePoint Team Sites is similar to saving to OneDrive for Business. The main difference is how you connect to the file from Power BI. You can specify a URL or connect to the root folder.
madyjoe21
👍 1
why not?
ET_phone_home_son
👍 1
Selected: DE
The answer depends on the requirement to be able to refresh the dataset in Power BI Service - of the choices here, only the Web and SharePoint Folder connectors permit scheduled refresh in PBI Service.
JJMC5544
👍 1
Selected: DE
Surely, when you use SharePoint Folder, you need to use root folder, not subfolders. Web is directly connection to excel file
Amosrab
👍 1
D and E
CrisRondaloGonzalez
👍 1
Selected: DE
To connect PowerBi to a one drive folder you need a digital link
inejo
👍 2
Hola de nuevo, es A y E, de acuerdo con este vídeo https://youtu.be/RSh3ZaPUX24
NLeeXTung
👍 2
Selected: DE
The question asks us "Dataset can be refreshed in PBI" so when the report published to any other owner's Workspaces it can be refeshed - Options A - B - C use the local address of your single file/folder although it stay in Onedrive but this is your synced local file/folder - Options D - E of course using web address (https://)
mhv22
👍 3
CHATGPT answer : To ensure that the dataset can be refreshed in powerbi.com from a Microsoft Excel file in a Microsoft OneDrive folder, you can use the following connectors: A. Excel Workbook: This connector allows you to connect directly to Excel files and import data from them into Power BI. D. SharePoint folder: Since the file is located in a Microsoft OneDrive folder, which is often associated with SharePoint, you can use the SharePoint folder connector to connect to the OneDrive folder and import the Excel file. Therefore, the correct connectors to use in this scenario are A. Excel Workbook and D. SharePoint folder.
PREM77
👍 1
Ans: (A)Excel Workbook and (D) SharePoint folder. option C (Folder) and option E (Web) are not the appropriate connectors for connecting to an Excel file in a Microsoft OneDrive folder.
Jagu_sheth
👍 1
Selected: AD
Excel Workbook and Sharepoint are the best methods to connect data in this scenario
SanaCanada
👍 1
The Web connector in Power BI allows you to connect to various web-based data sources, such as web pages, web APIs, and OData feeds. While it is not specifically designed to connect to OneDrive, you may be able to use the Web connector to access OneDrive data if you have a way to authenticate and access the API for your OneDrive account. However, using one of the other connectors specifically designed for OneDrive (such as Excel Workbook or SharePoint Folder) would likely be a more straightforward and efficient way to connect to your Excel file in OneDrive.
snrg564
👍 2
The correct connectors to connect to a Microsoft Excel file in a Microsoft OneDrive folder and ensure dataset refresh in Power BI are: A. Excel Workbook E. Web Explanation: A. Excel Workbook: This connector allows you to connect directly to an Excel file (.xlsx) stored in OneDrive and import data into Power BI. It provides a seamless integration between Excel and Power BI. E. Web: This connector enables you to connect to a file hosted on the web, including files stored in OneDrive. By providing the URL of the Excel file in OneDrive, you can import its data into Power BI and set up automatic refreshes. Both these connectors, Excel Workbook and Web, provide the necessary functionality to connect to a file in OneDrive and import it into Power BI while ensuring dataset refresh in Power BI service.
madyjoe21
👍 1
that is my understanding too
safz
👍 1
web is not recommended for connecting Excel files stored in OneDrive .
Shalaleh
👍 1
Selected: AD
Excel workbook is in OneDrive and OneDrive is cloud and we do not need a gateway.
SanaCanada
👍 2
Selected: AD
If the Excel file is stored in OneDrive, then the best connectors to use for refreshing the file in Power BI service are: Excel Workbook connector - This connector allows you to import data from an Excel workbook stored in OneDrive and create a dataset in Power BI. Once the dataset is created, you can publish it to Power BI service and set up scheduled refresh to ensure the data is up-to-date. SharePoint Folder connector - This connector allows you to access files stored in SharePoint and OneDrive for Business, including Excel workbooks. You can use this connector to import data from an Excel workbook stored in OneDrive, create a dataset in Power BI, and set up scheduled refresh. If the Excel file is stored locally on your computer or on a network drive, then the best connector to use for refreshing the file in Power BI service is:
SanaCanada
👍 6
Selected: AD
Further clarification The Web connector in Power BI is not the best option for connecting to an Excel file. There are other connectors specifically designed for connecting to Excel files, such as the Excel Workbook connector and the SharePoint Folder connector. The Web connector is best suited for connecting to web-based data sources that expose data through a URL or web address, such as web pages, web APIs, and OData feeds. To connect to an Excel file stored in OneDrive or SharePoint, you should use the Excel Workbook or SharePoint Folder connector, respectively. These connectors are specifically designed to connect to Excel files and allow you to import data from the Excel file and create a dataset in Power BI. Once the dataset is created, you can then publish the dataset to the Power BI service and set up scheduled refresh to ensure the data is up-to-date.
wellingtonluis
👍 1
Guys, How do you connect excel file in one drive via SharePoint ?
luojihencha
👍 1
AC are correct, tried, one drive is a folder after all.
pepix74
👍 2
From chatGPT: OneDrive is a web-based storage service. However, in the context of this question, option E (Web) is not a suitable connector to use for importing the Excel file to a Power BI dataset because the Web connector is designed for connecting to web-based APIs and web services, and not for importing files from cloud-based storage solutions like OneDrive. To import an Excel file from OneDrive to Power BI, it is recommended to use the Excel Workbook connector or the SharePoint folder connector, depending on how the file is stored. Therefore, in this specific scenario, option E (Web) is not the correct answer.
DUVANES
👍 1
Selected: DE
El archivo de .xlsx se encuentra en una carpeta de OneDrive, por lo que conectarse a ella puede ser atreves de una carpeta SP o Web
Akin_Eren
👍 2
Selected: AC
A and C seems correct -- if you connect to your excel file on one drive through Excel connection, the updates on one drive document are reflected on Power BI https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
PowerBiDAXSQL
👍 5
These tricky questions are so annoying.
mecham
👍 2
Selected: DE
Key Phrase :: Each correct answer presents a complete solution.
Mutti
👍 1
Wie so nicht A und C das ist doch viel sinnfoller!
ewelaela
👍 1
Selected: DE
Otherwise we would only connect locally and it would't be possible to refresh it in power bi service.
JainiFleischer
👍 1
A and C
Nikeferrr
👍 2
a make a test with my personal onedrive space from office 365 logged on my windows 11, then i can catch the excel using excel connectors and folder connector, its work but only personal onedrive, maybe on ONEDRIVE FOR BUSSINESS the answer is other.
LucianaFS
👍 3
This is a very tricky question. The options A and E are correct IF MIcrosoft OneDrive had syncronized with a folder at personal computer... Otherwise the answer is D and E.
marcionlinerj
👍 1
Selected: E
I Agree. E is a better solution.
KarthikKumarK
👍 6
Selected: DE
If data should be refreshed, Then refresh will work when the connectors are web or SharePoint folder. It means, data should be available all time (online). If we use local path, It required a gateways. Thanks Karthik
golden_retriever
👍 2
The question is tricky. It stated "OneDrive Folder", not "OneDrive for Business Folder", which turns to Sharepoint and has path. Mere OneDrive has no path at all.
Hoeishetmogelijk
👍 6
Selected: DE
D & E
Pauwels
👍 3
Selected: DE
I have Try them, A, B, C Totally impossible. E work D i got some errors surelly i miss something
lukelin08
👍 2
Selected: DE
D & E seem to be the consensus
Glubbs
👍 1
Selected: DE
To keep the dataset on powerbi.com updated, should be online. (I believe also must be considered the right OneDrive version - https://www.microsoft.com/en-ca/microsoft-365/onedrive/onedrive-for-business)
GuerreiroJunior
👍 5
Agreed KobeData
Namenick10
👍 2
Selected: DE
D & E correct
Churato
👍 4
Selected: DE
D and E. that's the way that I actually do on my job
Djibsonx7
👍 3
It's DE i think referred from https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
KobeData
👍 15
Works just fine, this is how you do it :)
Fer079
👍 19
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...
PinkZebra
👍 4
Selected: DE
Two options: - 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
fred92
👍 39
Selected: DE
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
Fer079
👍 98
Selected: DE
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
Kikong75
👍 2
and why not Excel Workbook?: I think that this connector allows you to connect directly to an Excel file stored in OneDrive for Business. While some may argue that it could create a "local copy," this connector actually connects to the file in the cloud and allows you to refresh the dataset (with scheduled refreshes) in PowerBI.com without the need for a gateway.
gstep
👍 2
A, D and E are valid answers, which two are tem more accurate?
9f73003
👍 2
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?
Shalaleh
👍 4
but OneDrive is cloud and we do not need a gateway.
NevilleV
👍 2
Try it. D and E won't work. Its looking for a URL
adrale26
👍 1
I think the option is Web insted of Excel woorkbook https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
zagiel
👍 2
You have to ensure that data wil be update. So should will be correct answer Sharepoint folder and web? Because you have to import Excel workbook and folder, but Web and Sharepoint folder update automatically.
nucleus21
👍 1
A.Excel workbook with web path to the file D.Sharepoint Folder with web path to OneDrive (sharepoint) root domain >navigation to file since it needs to be refreshed online option C will fail as it calls the folder from local path
Snow_28
👍 2
A. Excel workbook C. Folder
bjornopjemic
👍 6
Isn't Web an option as well? https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
NevilleV
👍 1
I dont think so. Where do you find a URL for One Drive
OGESSIUSER
👍 4
Selected: AC
A. Excel Workbook C. Folder
GPerez73
👍 2
It is correct for me
Guru1337
👍 1
So I agree with the answer, but I believe you could also use the Text/Csv connector. So B should in theory also be a valid answer.
NevilleV
👍 1
Not! The question states Excel file not Text/csv
GPerez73
👍 3
It says Excel file, so B does not meet the requeriment
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
The correct answers are D (SharePoint folder) and E (Web). OneDrive for Business is built on SharePoint Online infrastructure. To connect to a file stored there without using an On-premises Data Gateway, you must use connectors that natively support the cloud source. The 'SharePoint folder' connector allows access to the document library, and the 'Web' connector can utilize the direct download URL of the file. Both methods allow the Power BI Service to refresh the dataset autonomously.Why the Other Options Are Wrong
Options A (Excel Workbook), B (Text/CSV), and C (Folder) are typically used for local files. If these connectors point to a local path (e.g., C:\...), they will fail to refresh in the service unless an Enterprise Gateway is installed and configured. While the Excel Workbook connector can work with OneDrive if configured correctly in some contexts, the specific exam scenario and community consensus highlight that Web and SharePoint Folder are the definitive 'cloud-native' choices for this setup to avoid gateway dependencies.Community Comment Notes
Community members consistently identify D and E as the correct pair. As user Fer079 noted, "if we must refresh the data from the service with no gateways then We must use web and sharepoint connectors." User SanaCanada added clarification that while Web is suitable, SharePoint Folder is also a primary method for accessing OneDrive content. Multiple users confirmed passing the exam with this selection.Official Reference
Exam Strategy
When a question specifies 'refresh in powerbi.com' and the source is a cloud storage service like OneDrive or SharePoint, prioritize connectors that do not require a gateway. Avoid local file connectors unless the question explicitly mentions gateway configuration.
Frequently Asked Questions
Why isn't the Excel Workbook connector correct?
While it can work, the exam emphasizes connectors that inherently support cloud refresh without gateway ambiguity. Web and SharePoint Folder are the standard cloud-native solutions.
Can I use OneDrive links with the Web connector?
Yes, the Web connector accepts the direct link to the Excel file stored in OneDrive, allowing the service to fetch updates directly from the cloud.
Related Analysis
Practice All PL-300 Questions
Access 116 questions with complete answers and detailed explanations.
View Full PL-300 Practice Test →