Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!
Solved! Go to 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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |