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

[Anonymous]

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

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

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-manual-site-storage-limits

Best Regards,
Community Support Team _ Eason

[Anonymous]

Thanks

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

[GilbertQ]

Hi there

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

[Anonymous]

Hi,

Desktop

[GilbertQ]

Hi there

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

[Anonymous]

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?

[Anonymous]

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