Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DirectQuery workaround maximum allowed size with Top records

Hi,   using SQL Server Direct Query   I have a standard fact table visualised as 'Table' and dimension tables as 'Slicers'   the fact table has 100 mil records, so depending on the filters, the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I can't even do that, thanks to (excellent!) the PowerBi account restrictions/changes. Took me ages to be able to post on this forum, this is ridiculous to be honest (nothing to do with this issue apologies)

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-easonf-msft 

     

    not sure how to combine RANKX with selected filters, is it possible?

     

    Tried following this but I can't work out how to apply to my example