Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data Snapshot

Hi All, I am working with a dynamic dataset which shows total of aged stock units with no Date data available. This reports gets updated every day and shows the YTD data (total unit and break down ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dear TomMartens,

Thank you for your prompt advise on the above issue.

Since manually building history can be risky, I feel interfering with the process and adding features to the dataset with a date format will be the way to go.

Appreciate it!

Regards, 

 

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi Anonymous 

 

Power BI cannot store the history data for you. Every refresh in Power BI is a full refresh which will query data from data sources again, import new data to replace the old data in the dataset. Old data in the dataset will be removed after a new refresh is completed. So Power BI cannot record the historical refresh time or store historical data. 

 

You have to store those historical data in a data source outside of Power BI, e.g. an Excel workbook, a CSV file, a relational database, etc. Then connect to this data source to get all data into Power BI to create the report your want. You can use some automation tool or script to query data and save it to the file/database daily. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi v-jingzhang ,

    Thank you for your kind advise on this.

    This is noted.

    As per, I am trying to do some testing on this now.

    Will be in touch with the outcome soon, hopefully.

     

    Regards,