Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

To build a table with a historical data.

Hi,

I have a data source, but always that there is a change on this data, it don´t keep the last data.
My data source has always the data on moment.
I need to keep the historical data to analyse data and build the reports. 
I have a table A with data of data source. To save the historical data I am thinking to create a table B and always the Power BI is updated the table B save the data of table A. 

Is it possible to do using language M? How?

Thanks 

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Powerbi does not support the storage of historical data sources. The data returned by m query will directly retrieve the real-time data of the datasource.

    Here is a option of ‘inclued in report refresh’ in PQ .But it need ro be noted that this only disables the refresh of the query cache.Cache is not the same as storage. Once refreshed, the original data will still be updated.


    So the most important consideration is how to back up your historical data on your data source not in PowerBi. PowerBI is not suitable for storing historical data (Unless you don’t consider refreshing the data).

     

    For example, if your datasource is a daily excel in a folder,you shouldn't overwrite daily excel file rather add a new file for every day and then combine excel file in Power BI using the folder connector so that you have a big dataset from excel file for all the dates.

     

     

    Best Regards,
    Community Support Team _ Eason

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

    Powerbi does not support the storage of historical data sources. The data returned by m query will directly retrieve the real-time data of the datasource.

    Here is a option of ‘inclued in report refresh’ in PQ .But it need ro be noted that this only disables the refresh of the query cache.Cache is not the same as storage. Once refreshed, the original data will still be updated.


    So the most important consideration is how to back up your historical data on your data source not in PowerBi. PowerBI is not suitable for storing historical data (Unless you don’t consider refreshing the data).

     

    For example, if your datasource is a daily excel in a folder,you shouldn't overwrite daily excel file rather add a new file for every day and then combine excel file in Power BI using the folder connector so that you have a big dataset from excel file for all the dates.

     

     

    Best Regards,
    Community Support Team _ Eason

    • mex00277's avatar
      mex00277
      Frequent Visitor
      4 years ago

      Hi! I want to know if you found the solution to this issue. I have the same problem.

      Thank you!