problem with the refresh

[BrianM]

Hello, I have a little trouble it is last time with POWER BI DESKTOP, when the file is big that I try to refresh it takes almost 2 hours of waiting, it takes a lot of resources in the RAM and cpu and finally he wrote FAIL, but 2 weeks ago he did not take so much resource, it was not so long and it worked well he wrote not fail to end.

[v-jiascu-msft]

Hi @BrianM,

1. I would suggest you optimize your data model. Please refer to power-bi-reports-performance#optimize-your-model.

2. Remove unnecessary query steps in the Query Editor.

3. Upgrade the Desktop to the May 2018 release.

4. Try out this function if needed. query-bi/m/table-buffer.

Best Regards,

Dale