Forum Discussion

timcorke's avatar
timcorke
Helper I
4 years ago
Solved

Presenting progress over time from a single data set

Good morning experts,   I'm looking for a bit of guidance, I've got a single data set of c. 50,000 rows that contains a snapshot of IDs, their start time, wait time, their area of focus etc that is...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi timcorke ,

     

    Your data is updated twice a week, and each update removes historical data. You want to calculate the number of IDs per month without keeping the historical data, am I understanding you correctly?


    Unfortunately, currently Power BI can only do calculations on data imported into the model, not on deleted historical data.

     

    If you just want to export reports periodically, you can use Rest API (Reports - Export To File) and Power Automate to achieve that. If you want to do calculations on historical data, maybe try incremental refresh.

     

     

    Best Regards,
    Winniz


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi timcorke ,

 

Your data is updated twice a week, and each update removes historical data. You want to calculate the number of IDs per month without keeping the historical data, am I understanding you correctly?


Unfortunately, currently Power BI can only do calculations on data imported into the model, not on deleted historical data.

 

If you just want to export reports periodically, you can use Rest API (Reports - Export To File) and Power Automate to achieve that. If you want to do calculations on historical data, maybe try incremental refresh.

 

 

Best Regards,
Winniz


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.