Home

Refreshable Connections via Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-691327%22%20slang%3D%22en-US%22%3ERefreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691327%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20created%20an%20excel%20sheet%20that%20pulls%20data%20from%20two%20excel%20online%20sheets%20that%20are%20linked%20to%20forms%20filled%20out%20on%20a%20weekly%20basis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20it's%20in%20my%20onedrive%2C%20I'm%20the%20only%20one%20who%20can%20refresh%20it%2C%20which%20is%20less%20than%20ideal.%26nbsp%3B%20Is%20there%20any%20way%20to%20create%20it%20in%20such%20a%20way%20that%20multiple%20people%20could%20refresh%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-691327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691480%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691480%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360027%22%20target%3D%22_blank%22%3E%40Topher11%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20your%20question%20asking%20if%20you%20have%20your%20'Get%20Data'%20file%20in%20Sharepoint%20better%20than%20in%20your%20OneDrive%3F%3C%2FP%3E%3CP%3EDepends%20who%20has%20permissions%20to%20your%20Sharepoint%3B%20the%20same%20could%20be%20said%20about%20your%20OneDrive%20though.%20If%20you%20want%20other%20people%20to%20be%20able%20to%20Open%20and%20Refresh%20the%20data%20you'll%20have%20to%20give%20them%20permissions%20to%20the%20folder%2Ffile.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692610%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692610%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303863%22%20target%3D%22_blank%22%3E%40ChrisMendoza%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20that%20when%20I%20choose%20Get%20Data%20and%20then%20try%20to%20find%20the%20file%2C%20I'm%20unable%20to%20locate%20it%20because%20the%20only%20options%20I%20have%20are%20either%20to%20find%20it%20in%20OneDrive%20or%20import%20a%20list%20from%20Sharepoint.%20I'm%20trying%20to%20import%20the%20file%20from%20Sharepoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20that%20make%20sense%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-693027%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-693027%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360027%22%20target%3D%22_blank%22%3E%40Topher11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20From%20File-%26gt%3BFrom%20Sharepoint%20Folder%20connector%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerquery-m%2Fsharepoint-files%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpowerquery-m%2Fsharepoint-files%3C%2FA%3E.%20Here%20filter%20your%20file%2C%20click%20on%20Binary%20and%20extract%20the%20table.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-696314%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-696314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360027%22%20target%3D%22_blank%22%3E%40Topher11%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilar%20to%20what%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bis%20saying%2C%20except%20that%20navigation%20within%20the%20ribbon%20is%20not%20working%20like%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BI%20ended%20up%20using%20New%20Query%20%26gt%3B%20From%20Other%20Sources%20%26gt%3B%20From%20Sharepoint%20List.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20'Navigator'%20window%2C%20select%20an%20existing%20list%20then%20EDIT.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERemove%20any%20steps%2C%20leaving%20only%20Source.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20should%20be%20showing%3A%3CBR%20%2F%3E'%3DSharePoint.Tables(%22...%22)'%3CBR%20%2F%3EChange%20to%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E'%3DSharePoint.Files(%22...%22)'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20be%20able%20to%20see%20your%20Excel%2C%20CSV%2C%20etc.%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698429%22%20slang%3D%22en-US%22%3ERe%3A%20Refreshable%20Connections%20via%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698429%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F303863%22%20target%3D%22_blank%22%3E%40ChrisMendoza%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20here%20for%20O365%20with%20ProPlus%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20593px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119190i94DE64BBF96B115C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Topher11
New Contributor

I've created an excel sheet that pulls data from two excel online sheets that are linked to forms filled out on a weekly basis.

 

Because it's in my onedrive, I'm the only one who can refresh it, which is less than ideal.  Is there any way to create it in such a way that multiple people could refresh it?

5 Replies
Highlighted

@Topher11 -

 

Is your question asking if you have your 'Get Data' file in Sharepoint better than in your OneDrive?

Depends who has permissions to your Sharepoint; the same could be said about your OneDrive though. If you want other people to be able to Open and Refresh the data you'll have to give them permissions to the folder/file.

Hey @ChrisMendoza ,

 

My issue is that when I choose Get Data and then try to find the file, I'm unable to locate it because the only options I have are either to find it in OneDrive or import a list from Sharepoint. I'm trying to import the file from Sharepoint.

 

Does that make sense?

@Topher11 

 

You may use From File->From Sharepoint Folder connector https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files. Here filter your file, click on Binary and extract the table.

@Topher11 -

 

Similar to what @Sergei Baklan is saying, except that navigation within the ribbon is not working like that.

 

 I ended up using New Query > From Other Sources > From Sharepoint List.

 

In the 'Navigator' window, select an existing list then EDIT.

 

Remove any steps, leaving only Source.

 

It should be showing:
'=SharePoint.Tables("...")'
Change to:

'=SharePoint.Files("...")'

 

You should be able to see your Excel, CSV, etc. files.

 

@ChrisMendoza 

 

It's here for O365 with ProPlus 

image.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies