Forum Discussion
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...
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.
Please consider editing to read " I found it easier to create the query in Power BI Desktop, then copy the code from advanced editor over into a blank query."