Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Append query to dataset and remove outdated data

I want to have a dataset in my Power BI file with 2 years worth of transactional data. This creates over 600M rows.   Instead of refreshing the entire dataset each time I run the report, is there a...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

If you are using PBI Service, a data flow could take care of this.  I think its a little glitchy sometimes, but it should do data diffs so that you do not have to refresh the entire report.

 

Jared

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the reply. We don't have Power BI service, so I am using the desktop app. Is there any sort of solution for the desktop version?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Do you have a Pro license? Power BI Service is just the online capaiblities of Power BI.  You should have that access.

       

      I am not aware of a solution for PBI Desktop.  I am betting there is one, just not sure. Sorry!