Forum Discussion

PowerBI_Mallow's avatar
PowerBI_Mallow
Frequent Visitor
2 years ago
Solved

Best storage Option for Flat files

As our data size is growing in large volume, we are planning to purge the data and keep a backup as flat files and keep only the recent years of data in the main database. We would like to know wh...
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    2 years ago

    PowerBI_Mallow ,

     

     SharePoint impose the limitations on file sizes of 250 GB, I would recommend you have a server to store your data.

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago

How much data are we talking? What is your database type? Is it an on-premise SQL server? Cloud-based Azure? I'm definitely more of a front-end developer than a data architect or engineer, but I think the best solution is to not purge your old data and keep it in the database. 

 

What is the motivation to purge the old data and archive into flat files if you're still wanting to access it for analysis?