Append Data Flow to Semantic Model

[FECStevenL]

I'm running a query via data flow to fetch information from an Oracle database. The data in this database is replaced daily, there is no historical table saved.
I'm wanting to run this data flow daily to grab the information, and append it to a semantic model for historic trends and reports, is this possible?

[Anonymous · Accepted solution]

Hi @FECStevenL ,

@PwerQueryKees Thanks for your reply!

And @FECStevenL , the role of Power Query is essentially to preview data, which means that Power Query itself has no memory and does not store any data. You mentioned that the new data of your data source every day will overwrite the old data of the previous day, so Power Query can only see your latest data and cannot store your old data. The best approach is probably to copy all the data for backup each time new data is imported into Power Query.
And if you want to see your historical data, this may be a feature in Data Factory in Fabric, I found this post that may help you:
Dataflow Gen2 - Table not getting dropped and recr... - Microsoft Fabric Community
However, this is the Power Query forum. I cannot provide technical support related to Fabric. If you want to achieve your goals through Data Factory, please post in the corresponding forum of Fabric for help. A professional Fabric engineer will come to help you solve the problem.

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

[PwerQueryKees]

PowerQuery normally does not do append, but you may want to look at this: (thanks @v0ha )

https://exceleratorbi.com.au/self-referencing-tables-power-query/

https://www.youtube.com/watch?v=wHgv_gWw7iQ