Forum Discussion

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago
Solved

DirectQuery: Data source has exceeded the maximum allowed size of '1000000' rows

Hi,   I have two measures,   Functional Amt - SUM(FA), Transactional Amt = SUM(TA)   It works fine when I use these measures directly in visuals. However, it isn't working when I use the below...
Need Help
Tips and Tricks
  • SivaMani's avatar
    SivaMani
    7 years ago

    v-yulgu-msft,

     

    I tried this. But it's not working.

     

    I have achieved this using bookmarks.

     

    Thanks,

    Siva

SivaMani's avatar
SivaMani
Resident Rockstar
7 years ago

v-yulgu-msft,

 

I tried this. But it's not working.

 

I have achieved this using bookmarks.

 

Thanks,

Siva

Muratik55's avatar
Muratik55
Helper I
3 years ago

how did you use bookmarks?