Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Hi! I want to know if you found the solution to this issue. I have the same problem.
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |