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.

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello PowerBI_Mallow ,

 

I thinl parquet would be a better option, microsoft fabric is built on a parquet database so the flow of the data would go smoothly with a huge amount of data.