Dear support community,
A report that was refreshing fine needed a small tweak to a parameter due to a sharepoint folder where one of the datasources is located being renamed. I did this applied the change and the appropriate table refreshed with the data as expected. However now when now I refresh the complete report in Power desktop the refresh fails the the message for every table being:
"Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available."
If I upload the changed report to the service (overwriting the original) it refreshes according tot he schedule without issue. Other larger reports also refresh fine on the desktop. If I filter a core table on using top N records, cutting it down from 650 rows to 134 rows it will refresh, but that is tiny in terms of the data stored. Plus the the memory usage reported in task manager never exceeds 80% when it fails so it does not seem like a windows 11 issue on the local machine.
I have tried the following but without it solving the issue.
- Clearing caches
- Reinstalling Power Bi on local machine.
- Running this report on a different
- Reducing the number of concurrent queries and therefore upping the available memory per query
- Changing the query steps to ensure there is no unnecessary data items. or irrelevant steps.
