Forum Discussion

vehau1's avatar
vehau1
Helper I
7 years ago

Dataflows: Import from Sharepoint folder

  I want to gather all my dataflows in one app space. Part of this data is an Excel Workbook that's placed in a Sharepoint page that I own.   I want to connect to and import this Excel file as a d...
Need Help
Tips and Tricks
Veles's avatar
Veles
Advocate V
7 years ago

vehau1

 

I've managed to find a workaround. Select Blank Query and then enter the below as the source. Click next and you can go from there. You would just enter the URL that you would normally do when you select SharePoint Folder in the desktop version.

 

Source = SharePoint.Files("https://[YOURSITE].sharepoint.com/sites/[YOUR SITE]/", [ApiVersion = 15])

It looks like it's a bit cut down though so there's no button to automatically combine files together as you can in desktop.

 

EDIT: Managed to get the file combination working with a bit of tweaking - I found it easier to create the query and desktop then copy the whole lot over into a blank query.

smagbuo's avatar
smagbuo
Frequent Visitor
7 years ago

I'm doing the same workaround but haven't been successful. I'm copying every query associated to the combine method including the fx (invoke function) since the main query (Query1 - which combines all the files in the specified SharePoint folder) is breaking due to missing referenced module. Could you share here the steps you did? Did you have to copy over all the Sample Queries within Transfor File from Query folder as well?