Forum Discussion
Transpose Too Complex? File too big? What to do?
I am working on transitioning POS data from Excel to PowerBi because the file is growing too big to update (600MB). Right now, each row is one item with both repeated columns of identifier data and ...
amitchandak
Super User
Super UserAnonymous , Not very clear, but check if Dax append method can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/