Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Append and keep data

Because of SalesForce 2000 row limitation, I download reports to Excel and then import into Power BI, transform data and create reports. I need all the data from two years so I can show comparative p...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    @goldmanf

     

    Your requirement should be same as this thread, but I don’t think it is supported now. So we can just use some alternatives to do it.

     

    Best Regards,

    Herbert

  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks, again. This is the same concept and I really appreciate the response. 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks, but once a query hits 2000 rows, you'd have to create a new query and append again. At some point, it will take many queries to continue the data. 

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

@goldmanf

 

Your requirement should be same as this thread, but I don’t think it is supported now. So we can just use some alternatives to do it.

 

Best Regards,

Herbert

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thanks, again. This is the same concept and I really appreciate the response.