Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Direct Query Measure Issue with 1M rows...

Currently I have a measure in Power BI supported by a direct query model.  The formula for the measure is a simple count of records on a table filtered by another measure.   Expression: Filtered ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Anonymous,

 

I found your measure calculate through multiple tables, I think the issue may related to loop calculate, count of the calculate exceed the 1M.

 

For example:
Table1, 10k + rows, dim table, 100k+, loop calculation count 10K *100K=1M

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

And this is something normal and acceptable using DQ?

This is something that should be able to work properly on the product since I am not returning more than 1M rows but yes calculating using joined tables that exceed 1M rows... This scenario is very common, no one is having this kind of issue?


Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    >>This is something that should be able to work properly on the product since I am not returning more than 1M rows but yes calculating using joined tables that exceed 1M rows... This scenario is very common, no one is having this kind of issue?

    Actually, I still not sure which place will cause your issue.(I can't reproduce this)

    I'd like to suggest you contact to power bi team to know the detailed information about the this issue.

     

    Regards,

    Xiaoxin Sheng