Forum Discussion
DirectQuery Dataflow not working in premium capacity workspace
HI MAG_PRG ,
The fact that the production is premium and dev is not should not be an issue. The premium will have MORE capabilities than a non-premium site so that will almost certainly not be a factor.
If this works in dev, then the data source should be a support data source. As seen here: (Power BI data sources - Power BI | Microsoft Learn)
This leads me to think that the issue may be in the connection - that the data source or gateway does not allow you or your userid to use the Power BI connection and/or your userid does not have permissions to the production data, even though you do have dev access. Could that be it?
What exactly is the error message that you are receiving?
And, here is a link with some overview that may be helpful (or you know this all already 🙂 )
DirectQuery in Power BI - Power BI | Microsoft Learn
Hi
When I tested with a dataset using the dataflow that was also pushed through the pipeline, which had a direct query connection to it in dev and test, I would get the error that the datasource did not support query folding in production.
If I use a fresh report and connect directly to in in prod I am not getting an error message, I am just not given the option of a direct query connection