Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Error creating or editing Dataflows

Whenever I try to create a dataflow it gives me "unexpected error" during the data load part with no mayor explanation. Nonetheless, my colleague can create the same Dataflow with no issues. Finally ...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, that's a good question, I tried and I'm able to create dataflows from OneDrive.

 

The ones I need to create are connections to a Sharepoint Folder, for which I am getting the error. The unexpected error happens after I try to merge files in a sharepoint folder, after showing me the data and transformations, when I click load the table, it shows the unexpected error. After that it just shows me loading data and never ends.

 

 

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi Anonymous ,

 

I cannot reproduct your problem, this is my test.

 

1. My datasource is OneDrive for Business, use the SharePoint connector. Go to OneDrive and grab the URL. It will look like this:

 

Then combine and merge files, no errors were generated.

 

     

 

There is workaround: copy & paste the main query code from the Desktop advanced editor to the dataflow, copy the query code from the custom function for combining files from the Desktop advanced editor and somehow work it into the main M code in the dataflow.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.