Forum Discussion

db042190's avatar
db042190
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

direct query vs dax layer

hi we think the refresh max of 48 times per day wont be frequent enough to satisfy one of our pbi requirements.  so we start thinking about direct query but notice that perhaps adding a very importan...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi, db042190 

    Sure, there is no data pane in Direct Query mode , but you can also create some measures or calculated column in Report view or in the Model View.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , db042190 

You can try to click One table in the "Data" Pane, and you can click "New Measure" or "New Column" to create a measure or calculated column.

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

db042190's avatar
db042190
Icon for Impactful Individual rankImpactful Individual
3 years ago

do you mean in "modeling" mode?  i do not believe there is a data pane available when direct query is chosen.

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, db042190 

    Sure, there is no data pane in Direct Query mode , but you can also create some measures or calculated column in Report view or in the Model View.

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly