Power BI Refresh Issue Due to Excel File Size

[cyborgandy]

Hi all I have linked my power dashboard to an excel file, now the excel file is above 400 Mb and now when I am trying to refresh my power bi dashboard , I am getting below error, could someone help me with any solution to fix this issue.

[AlanP514]

HI @cyborgandy 

Schedule refresh only works for Cloud data source only, If your Data source is in excel or CSV means you have to implement Gateway connection

Hope its clear for you

[cyborgandy]

@AlanP514 I have this datasaved in sharepoint where I keep updating the latest datset in the same excel, this month whrn I updated the shapoint excel file and trying refreshing my dashboard its not allowing me to refresh, is it because the excel file size has now gone to 450 mb? any sugestion for this would be very helpful

[AlanP514]

Hi @cyborgandy 

Please check your data source credentials