Dataflow refresh error

[Anonymous]

I have a dataflow in a Workspace that gives me the following error message when I try to refresh it. It used to work fine but after using the dataflows in this workspace for a few days, most of the dataflows are giving me this error except a couple. 

ErrorMessage:"Refresh has failed unexpectedly. This indicates in most cases an out of memory issue in your capacity. Please check the capacity configuration metrics and try again."}

As a test, I recreated this dataflow in a different Workspace and it worked fine and gave me no error. This particular dataflow fetches data from an excel file on sharepoint and there's only 20-30 rows in the file.

[lbendlin · Accepted solution]

Remove the affected workspace from the capacity and add it back in.  There's a known incompatibility between dataflows and the Gen 2 service .

[Anonymous]

Yep, workspace was the culprit. 

I created a new workspace, exported dataflows as JSON files and imported them into the new workspace and I don't get any silly error messages.