Forum Discussion

SteveCarter1's avatar
SteveCarter1
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Memory blow out importing Excel/XML files

Hi I have a Windows Server 2016 Std with 8 cores / 32GB in Azure. It's only job is to run my on-premises data gateway.   I have 1 report that uses imported Excel & XML formatted files extensively,...
  • SteveCarter1's avatar
    3 years ago

    Okay this was weird.  I hadn't touched development of this report for a while - at least a few months.

     

    I downloaded it from the service, opened it in Power BI Desktop (Feb 2023 release), then I made a change to a text box, manually refreshed it then uploaded back to the service.

    Now, with the same input files, the gateway service only uses 500MB more than at idle.

    I've refreshed within the service and it's the same. So it appears to be 'resolved'.

     

    If anyone else comes across this, have a think how old the report is and I guess try downloading it, making an insignificant change just so the report itself has changed, manually refresh on your workstation then re-upload and see how the refresh goes there again.