Forum Discussion
Dataflows: Import from Sharepoint folder
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 |