Forum Discussion
Dataflows: Import from Sharepoint folder
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."
Does anyone know if using this method of accessing sharepoint files and pulling them into a dataflow is subject to a size limit? It seems that when I use this metholdology to access smaller files, manipulate them in a query and then save them as a dataflow it works fine. But I have a few situations then the transformations require appending and merging data from separate tables. It seems to save OK, but when I go to refresh the dataflow I get an error similar to this - makes me think that larger more complex transformations using this metholdology fail for some reason - any thoughts?
Run time Dataflow name Dataflow refresh status Entity name Start time End time Entity refresh status Error 24/04/2019 11:20:55 Report Failed Report 24/04/2019 11:20:55 24/04/2019 11:21:26 Failed Error: We're sorry an error occurred during evaluation. Request ID: 0500d1d7-d106-7e47-0987-fa523e7924a7 Activity ID: 4486d774-3b83-4623-9f18-12d17b06e662