cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Agaidar
Helper I
Helper I

Sharepoint error: the file size exceeds the limit allowed and cannot be saved

Hi Team,

 

I'm trying to automate my power bi reports and need to change sourcing to the sharepoint location. However, I get below error:

 

DataSource.Error: The file size exceeds the limit allowed and cannot be saved

 

Sourcing file size is 371 MB (csv) and can't be reduced or split because it is a master file and entire organization use it as source file. 

 

Any ideas how to fix it?

 

Thankful in advance!

Aidar

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi , @Agaidar 

You may need to configure your sharepoint storage in order to save the large file. You can refer to this solved thread.

 

Please check  this document  about how to manage sit storage :

https://docs.microsoft.com/en-us/sharepoint/manage-site-collection-storage-limits#set-automatic-or-m...

 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

7 REPLIES 7
v-easonf-msft
Community Support
Community Support

Hi , @Agaidar 

You may need to configure your sharepoint storage in order to save the large file. You can refer to this solved thread.

 

Please check  this document  about how to manage sit storage :

https://docs.microsoft.com/en-us/sharepoint/manage-site-collection-storage-limits#set-automatic-or-m...

 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

Thanks

 

I will talk to our IT team. Sharepoint storage manages offshore

GilbertQ
Super User
Super User

Hi there

Are you accessing this file directly in the Power BI Service or on Power BI Desktop




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi,

 

Desktop

Hi there

What happens if you download the CSV file and load it from your PC does that work?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hey GilbertQ,

 

I can load the .aacdb file into power BI when I have it saved locally on my computer. But other memebers of my team want to use the .pbix file, so we have to change the address of the .aacdb everytime someone else wants to use it. Is there no way avoid this step?

That what happenig now, but I want to avoid this step and connect my pbi desktop directly to sharepoint and afterwards set up gateway and schedule refresh.

 

My ultimate goal is report refresh automatization

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!