Forum Discussion
DirectQuery Dataflow not working in premium capacity workspace
Hi, MAG_PRG
You need to verify that your user account has the necessary permissions to access the dataflows in your production workspace, which may vary between environments. Also make sure that the data source you're connecting to supports DirectQuery in Premium capacity, and there may be differences in how the data source is handled between different environments. See if there are any error messages or look at the logs, which may provide clues.
You can check the following link:
Using DirectQuery with dataflows - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
If I attempt to use the dataflow thorugh a dataset that has been pushed through a pipeline, and therefore expects the dataflow to have a direct query connection, I am getting the error message "We couldn't fold the expression to the datasource" on any visual that attempts to use a field from the dataflow.
If I try to connect to the dataflow from a fresh report, not run through the pipeline, I am not getting an error message, I am just not given the option of using direct query, it goes straight to import mode.
If the issue was related to my users security access I'd expect to get an error attempting to use the dataflow with import mode as well, and my user should have all accesses for the production workspace.
The only thing I can figure is that for some reason it does not consider the dataflow to be eligible for a direct query, but the only difference is which workspace it is in, I've enabled enhanced compute engine, and the only difference I can think of is that production uses premium capacity.
I read the links you posted, but I was unable to find anything related to premium capacity or any other reason it should not work for me