Forum Discussion

rabelonsknow's avatar
rabelonsknow
New Member
6 years ago

Auto created query returning <=100 text fields lenght

Hi, when looking at all queries in Dax Studio I see that power Bi performs auto queries in order to find out if some fields contain strings lower than 100 caracters. I do not know why power bi does it but these are the most time demanding queries in my model.

This is the code: "DProdutos'[AUXILIAR]" is a field in my products table. 

 

Why does it happen? Can I set power bi do skip these queries?

 

EVALUATE
SELECTCOLUMNS (
    FILTER (
        VALUES ( 'DProdutos'[AUXILIAR] ),
        LEN ( 'DProdutos'[AUXILIAR] ) <= 100
    ),
    "valueColumn", 'DProdutos'[AUXILIAR]
)

Need Help

1 Reply

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi rabelonsknow 

     

    Sorry, I don't quite understand your request. the formula in your post will return a table with filtered rows by one column. and it worked in power bi. isn't your expected results? if not, please kindly share more details about your requirement.