Forum Discussion

db042190's avatar
db042190
Impactful 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

     

db042190's avatar
db042190
Impactful Individual
3 years ago

thank you but without the data icon, what clicks/steps do we follow to add the allowable calcs and measures?

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community 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
    Impactful 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
      Community 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