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 measure,

IF(Ind =0, Functional Amt,Transactional Amt)

 

Getting Error Message:
The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows

 

Kindly assist me.

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

5 Replies

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      7 years ago

      It's just a number in a table,

       

      NameInd
      TA0
      FA1
      RA2
      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi SivaMani,

         

        Please try this:

        Measure =
IF ( SELECTEDVALUE ( Table[Ind] ) = 0, [Functional Amt], [Transactional Amt] )

         

        Best regards,

        Yuliana Gu