Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
3 years ago

max file in the sharepoint folder

Hi

I make a report who relie on csv file in a sharepoint site.

I will have one file per week so actually i have data from 2022, 52 files

 

Will it be problem in few time for the refresh when the number of file will increase, for example i want to put all 2021 so 52 more files and so one for all week in 2023

 

Thanks

 

Need Help

2 Replies

  • jaweher899's avatar
    jaweher899
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Having a large number of files in a SharePoint site can potentially impact the performance of the report refresh in Power BI, especially if the size of the individual files is large and the number of files continues to grow over time.

    Here are a few tips that can help minimize the impact on performance:

    1. Consider optimizing the file structure and size, for example by compressing or splitting large files into smaller ones.

    2. Make use of efficient file naming conventions, such as using date stamps or incremental numbering, to ensure that the report only refreshes the necessary files.

    3. Monitor the performance of the report refresh regularly and consider adjusting the refresh frequency if necessary.

    4. If the report performance continues to degrade over time, consider using a data source other than SharePoint, such as Azure SQL Database or Azure Data Lake Storage, which are designed for big data scenarios and can handle larger data sets.

    • nicolast29's avatar
      nicolast29
      Icon for Helper V rankHelper V
      3 years ago

      Yes but what is a normal limite in term of file

      Actually i have 72 Files each of 14Ko