Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

dataset refresh issue

Hi,

I have build a report using 4 datasets with 10 tabs and size approximately 1.5 gb. As data is increasing reports are getting failed to refresh automatically due to memory failure at source which here is SAP Hana.

Could someone please advise how to resolve the issue? I believe adding filters in report won't help as first data comes to the report and then filter are applied.

Any help will be appreciated.

 

P.S.-No relationship between any of the 4 dataset.

Thanks

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Generally that is an issue that needs to get fixed on the SAP side of things, a least that is what all of the threads about this kind of thing indicate.

     

    You could check the Issues forum here:

    https://community.powerbi.com/t5/Issues/idb-p/Issues

    And if it is not there, then you could post it.

    If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Greg,

       

      Thank you for responding. I agree with you that issue is at SAP but can I perform something in .pbix to make automatic refresh work again?

      I am using import/full load for refreshing the report.