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. 

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

Anonymous

 

You can load the first query/second query into two worksheets, and then using Power BI Desktop to load different queries from different worksheets. Now we should be able to keep all data after appending.

 

Best Regards,

Herbert

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.