Forum Discussion

cyborgandy's avatar
cyborgandy
Helper II
3 years ago

Power BI Refresh Issue Due to Excel File Size

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 m...
Need Help
AlanP514's avatar
AlanP514
Post Patron
3 years ago

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's avatar
    cyborgandy
    Helper II
    3 years ago

    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's avatar
      AlanP514
      Post Patron
      3 years ago

      Hi cyborgandy 

      Please check your data source credentials