Forum Discussion
DirectQuery Dataflow not working in premium capacity workspace
Hi
It's unlikely to be a connection issue, it works with import mode, just not direct query. I'm not getting any error messages, I'm just not given the option to choose between direct query and import. I've tried it from starting a blank report in desktop.
Edit: When I tested with a dataset using the dataflow that was also pushed through the pipeline I would get the error that the datasource did not support query folding when it connected to prod instead of dev/test.
This would make sense if it'd forgotten to turn on enchaned compute engine, but I've double checked that it's on and refreshed several times after, and it's been fine in dev and test workspaces.
The dataflow is pushed through a pipeline, I don't know if that could cause any issues, but I don't swap out any data sources, and it worked from dev to test.