"dynamic" path using get data.

%3CLINGO-SUB%20id%3D%22lingo-sub-2089566%22%20slang%3D%22en-US%22%3E%22dynamic%22%20path%20using%20get%20data.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2089566%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EScenario.%3C%2FP%3E%3CP%3EMultiple%20Excel%20files%20stored%20in%20SharePoint.%3C%2FP%3E%3CP%3EUsing%20Get%20data%20to%20make%20a%20report.%20From%20Fil%2C%20From%20folder%20(SharePoint%20is%20not%20an%20option%20in%20my%20Excel)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%2C%20the%20source%20path%20is%20locked%20to%20my%20User%3A%26nbsp%3BC%3A%5CUsers%5CGeir%20Hogstad%5C%20So%20other%20users%20receiev%20error%20when%20they%20update.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20is%20possible%20to%20make%20the%20path%20%22universal%22%20so%20every%20users%20with%20access%20to%20the%20Sharepoint%20site%20can%20update%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3E-%20Geir%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2089566%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090957%22%20slang%3D%22en-US%22%3ERe%3A%20%22dynamic%22%20path%20using%20get%20data.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090957%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9195%22%20target%3D%22_blank%22%3E%40Geir%20Hogstad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EI%20have%20doubt%20that%20you%20might%20not%20using%20the%20correct%20Excel%20version%2C%20check%20the%20below%20link%26nbsp%3B%3CSPAN%3Edetails%20versions%20of%20Excel%20which%20include%20the%20Get%20%26amp%3B%20Transform.%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fwhere-is-get-transform-power-query-e9332067-8e49-46fc-97ff-f2e1bfa0cb16%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWhere%20is%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EYes%2C%20It%20is%20possible%20to%20make%20universal%20path%20(subject%20you%20have%20correct%20Excel%20version)%26nbsp%3Band%20you%20can%20keep%20the%20data%20on%20the%20SharePoint%20so%20everyone%20can%20easily%20access%2C%20Infact%20it%20is%20a%20recommend%20solution.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2093121%22%20slang%3D%22en-US%22%3ERe%3A%20%22dynamic%22%20path%20using%20get%20data.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2093121%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3BI%20have%20the%20Office%20365%20Bussiness%20Standard%20edition.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20SharePoint%20option%20is%20%22From%20Online%20Services%22%20under%20the%20Get-menue.%20And%20its%20not%20an%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22online%20services.PNG%22%20style%3D%22width%3A%20336px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F249080i250FBBBC42E4B3E4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22online%20services.PNG%22%20alt%3D%22online%20services.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20What%20should%20the%26nbsp%3B%3CSPAN%3E%26nbsp%3Buniversal%20path%26nbsp%3Blook%20like%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20it%20possible%20to%20change%20it%20in%20teh%20settings%20for%20datasource%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBest%20Regards%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20Geir%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EBest%20Regards%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E-%20Geir%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Hi,

 

Scenario.

Multiple Excel files stored in SharePoint.

Using Get data to make a report. From Fil, From folder (SharePoint is not an option in my Excel)

 

Problem, the source path is locked to my User: C:\Users\Geir Hogstad\ So other users receiev error when they update.

 

Is is possible to make the path "universal" so every users with access to the Sharepoint site can update?

 

Best Regards

- Geir

 

 

2 Replies

Hi @Geir Hogstad 

 

  1. I have doubt that you might not using the correct Excel version, check the below link details versions of Excel which include the Get & Transform. Where is Get & Transform (Power Query) - Excel (microsoft.com)
  2. Yes, It is possible to make universal path (subject you have correct Excel version) and you can keep the data on the SharePoint so everyone can easily access, Infact it is a recommend solution.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.

Thank you @Faraz Shaikh I have the Office 365 Bussiness Standard edition. 

 

I think SharePoint option is "From Online Services" under the Get-menue. And its not an option.

 

online services.PNG

 

2. What should the  universal path look like?

 

Is it possible to change it in teh settings for datasource?

 

Best Regards

- Geir

 

 

Best Regards

- Geir