Forum Discussion

SylviaLiu's avatar
SylviaLiu
Regular Visitor
4 years ago

Unable to use DirectQuery with dataflows in PPU workspace

I tried to use DirectQuery with dataflows but failed. Could anyone help me to find the reason?   I've already read the doc about this function on official website. Here is the link: https://docs.mi...
Dataflow
Need Help
SylviaLiu's avatar
SylviaLiu
Regular Visitor
4 years ago

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?

 

bcdobbs's avatar
bcdobbs
Community Champion
4 years ago

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.

  • SylviaLiu's avatar
    SylviaLiu
    Regular Visitor
    4 years ago

    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.

    • bcdobbs's avatar
      bcdobbs
      Community Champion
      4 years ago

      I've certainly run direct query against a dataflow using a premium per user licence so don't think that's the issue.