Forum Discussion
Unable to use DirectQuery with dataflows in PPU workspace
Hi, SylviaLiu
It works fine on my side. Please make sure that the Enhanced Compute Engine is in an ‘On’ state.
If after reviewing the steps and limitations mentioned in this document, you still only see the table icon instead of the view icon in Power BI Desktop, we recommend that you try again after clearing your local data source credentials. ( File > Options and settings > Data source settings > Delete Power BI dataflows)
Best Regards,
Community Support Team _ Eason
Hi v-easonf-msft ,
I've already set Enhanced Compute Engine 'On', here is the screeshot below. But it still doesn't work.
Today, I found a document on blog mentioned that the enhanced compute engine on premium capacity should be enhanced before the dataflow's. But I can't find where to set this.
Now I have PPU license, but my organization didn't buy premium capacity. The settings page of our PPU workspace looks like this. We could not shift to large dataset storage format. Could this be the reason?
Which dataflow connector are you using in power bi. There are two...
Power BI Dataflow and Dataflow
Last time I tried only the later one supports query folding which is required for direct query.
Hi bcdobbs ,
I tried both, Power BI Dataflow & Dataflow, but neither worked.
Is your dataflow in premium capacity? We don't have premium capacity, so I'm not sure whether this would be the cause.
I've certainly run direct query against a dataflow using a premium per user licence so don't think that's the issue.
