Forum Discussion
Path to onedrive folder office 365 home
Ik wil regelmatig PDF-bestanden vanuit een specifieke OneDrive-map importeren in Excel met behulp van Power Query.
De map in OneDrive is de standaardmap voor e-mailbijlagen.
De bestandsnamen variëren dagelijks.
Ik gebruik de methode "Vanuit SharePoint-map" in Power Query.
Mijn probleem is dat ik geen geldig pad kan vinden.
Ik verkrijg het pad door een Excel-bestand in de bronmap aan te maken, dit op het bureaublad te openen en vervolgens het pad te kopiëren via "Bestand", "Info".
Dit levert me het volgende pad op:
https://d.docs.live.net/CCFXXXXXXXXX2A2/E-mailbijlagen/
Vervolgens kort ik het in tot:
https://d.docs.live.net/CCFXXXXXXXXXX2A2/
Als ik dit pad als URL invoer in het Power Query-dialoogvenster via de SharePoint-mapmethode, krijg ik de volgende foutmelding:
De opgegeven URL verwijst noch naar een OData-service, noch naar een feed: 'https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=183&ct=17'
Hoe kan ik een werkend pad genereren?
DirkP wrote:Syncing the folder locally using OneDrive isn't an option either, as I already have a synced OneDrive folder, and only one is allowed.
Natürlich kann es nur ein OneDrive Verzeichnis geben. Du sollst (und kannst) ja kein neues anlegen. Aber in diesem Verzeichnis kannst Du beliebig viele Unterordner mit beliebig vielen Dateien anlegen und diese auch aufrufen. Und die in OneDrive vorhanden Subfolder und Dateien sind auch im lokalen Verzeichnis vorhanden.
Der Aufruf von https://d.docs.live.net/CCFXXXXXXXXX2A2/E-mailbijlagen/
müsste dann so aussehen: C:\Users\User\OneDrive\E-mailbijlagen\
13 Replies
v-ssriganeshCommunity Support
Hello DirkP,
Thank you for posting your query in the Microsoft Fabric Community Forum.
OneDrive personal / Office 365 Home uses the d.docs.live.net format, which is not a SharePoint site and therefore cannot be connected using “From SharePoint Folder” in Power Query. That connector only works with OneDrive for Business / SharePoint Online URLs.
For a personal OneDrive, you’ll need to either sync the folder locally using the OneDrive desktop app and then use Folder as your data source, or move the PDFs to a OneDrive for Business or SharePoint Online location so you can use the SharePoint Folder connector. There is no valid SharePoint path for d.docs.live.net URLs, so Power Query cannot generate one.Best regards,
Ganesh Singamshetty.Hello
So, onedrive personal works as designed.
Unfortunately, it's not the solution I would have liked.
Thnx
Dirk
- v-ssriganesh
Hello DirkP,
Yes, that’s correct OneDrive Personal works as designed and unfortunately it isn’t supported for direct folder-based ingestion in Power Query. you may consider submitting this as a feature request in the ideas forum: https://community.fabric.microsoft.com/t5/Ideas/ct-p/PBI_Comm_Ideas. This allows the product team to track customer demand for supporting OneDrive Personal as a data source.Best regards,
Ganesh Singamshetty.
- ralf_anton
Resolver I
Hi Dirk,
die synchronisierten Daten solltest Du im lokalen Verzeichnis C:\Users\User\OneDrive finden...
I've mapped one OneDrive account to my PC. Since this isn't possible for a second OneDrive, this isn't a solution.
I've also tried to solve this problem by mapping the OneDrive as a network connection. Unfortunately, that doesn't work.- v-ssriganesh
Hello DirkP,
Thank you for the clarification.Currently, the only supported options are:
-
Use OneDrive for Business or SharePoint Online, which works with the From SharePoint Folder connector, or
-
Introduce an intermediate step (for example, a scheduled process or manual sync) to copy the PDFs from OneDrive Personal to a supported location.
There is no supported way today to periodically import files directly from a OneDrive Personal attachment folder using Power Query.
Best regards,
Ganesh Singamshetty -
- v-ssriganesh
Hello DirkP,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Thanks for the suggestions.
Since I don't have OneDrive for Business or SharePoint Online, this isn't an option.
Syncing the folder locally using OneDrive isn't an option either, as I already have a synced OneDrive folder, and only one is allowed.- ralf_anton
DirkP wrote:Syncing the folder locally using OneDrive isn't an option either, as I already have a synced OneDrive folder, and only one is allowed.
Natürlich kann es nur ein OneDrive Verzeichnis geben. Du sollst (und kannst) ja kein neues anlegen. Aber in diesem Verzeichnis kannst Du beliebig viele Unterordner mit beliebig vielen Dateien anlegen und diese auch aufrufen. Und die in OneDrive vorhanden Subfolder und Dateien sind auch im lokalen Verzeichnis vorhanden.
Der Aufruf von https://d.docs.live.net/CCFXXXXXXXXX2A2/E-mailbijlagen/
müsste dann so aussehen: C:\Users\User\OneDrive\E-mailbijlagen\
- v-ssriganesh
Hello DirkP,
Thanks to ralf_anton for sharing valuable insights.Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
- v-ssriganesh
Hello DirkP,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
- v-ssriganesh
Hello DirkP,
Just following up to see if you’ve had a chance to look at my previous message and whether your question was resolved by the solutions provided. This information could be useful for others facing similar issues.
Thank you.
