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 me with any solution to fix this issue.

 

 

Need Help

3 Replies

  • 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