Sharepoint folder - Storage limits?

[varelapablo90]

Hello everyone

Based on the following solution I´ve created a report in Power Bi where I upload about 100mb excel files per month with raw data (about 6-7 files). 

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

For 6 months of data (600mb in excel files) it seems to work quite well, but when I am testing a future scenario having 12 or more months of data the data set is not getting refreshed in the power bi service. 

Is this because there are storage limits on Shaporepoint that Power Bi can not handle or is it another issue?

Are there any best practices recommended to avoid this kind of errors? 

Look forward to your help, thanks!

[Anonymous · Accepted solution]

Hi @varelapablo90 ,

There is a 1 GB limit per dataset that is imported into Power BI. 

You can refer to this article to reduce the size of the data set.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.