Forum Discussion

Sudharshan1919's avatar
Sudharshan1919
Helper III
4 years ago
Solved

Report Not refreshing in Service

Hi All,   I have developed a report with the source as 3 excel files which is 3 different regions. It was not refreshing in the service and when as i checked the file size of the excel sheets are a...
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • Sudharshan1919's avatar
    Sudharshan1919
    4 years ago

    Got the solution for this... It is happening because the data size for each of the excel is more than 250MB and the service  will not handle that large kind of datasets. So i have reduced the datasets nearly to 100MB (each file) and deployed and now the report was refreshing and working fine. ( I am having Pro Version and using the Personal Gateway)

ibarrau's avatar
ibarrau
Super User
4 years ago

Hi. About both approaches (all excels and only two), can you share the error you are getting from Service? Can you also share how much is the pbix file size?

Those might help us understand.

Regards,

  • Sudharshan1919's avatar
    Sudharshan1919
    Helper III
    4 years ago

    Hi,

    Below are my excel files (source)

    I have checked all the required details

     

    Below is the error i am getting. It hasnt given any description of the error, except the below

    Below is for the sizes  of PBIX Files.

     Thanks

    • ibarrau's avatar
      ibarrau
      Super User
      4 years ago

      Ok. It looks like there is no issue with the sizes for the data model. About the picture with the error I can't see any error detail. Just "failed". It should say something else regarding the error to help us help you. Otherwise the only thing I can say is try Standard gateway instead of personal.

      Regards,