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.

Nithinr's avatar
Nithinr
Icon for Resolver III rankResolver III
2 years ago

Csv is not recommended if your row data have ',' it would be big effort to query and get data from csv. Parquet is best option to store it has good compression which reduces file size and smaller files makes it easy to read and write.