Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 6 tables in Power BI data flow. by consolidating and Transforming these tables I have created one Final table.
With the Final table i have created the dashboard. My Finaltable contains only refresh day data (only the data of the day i refresh).
I want this table to contain or store past data. I have a premium subscription. How to achieve this.
Regards,
TK
Solved! Go to Solution.
Hi @TamilselviK ,
When the data is stored in the data stream and the data source is deleted, when the data is refreshed, the historical data will be lost because the historical data does not exist. On this basis, first ensure that the data source exists, and then create a data flow entity to save historical data, and then configure incremental refresh to obtain historical data.
For details, please refer to the following blog.
Historical Data Preservation using Power BI Dataflow - Visual BI Solutions
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @TamilselviK ,
When the data is stored in the data stream and the data source is deleted, when the data is refreshed, the historical data will be lost because the historical data does not exist. On this basis, first ensure that the data source exists, and then create a data flow entity to save historical data, and then configure incremental refresh to obtain historical data.
For details, please refer to the following blog.
Historical Data Preservation using Power BI Dataflow - Visual BI Solutions
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.