i have been having issues for some time reguarding report size and have been working to reduce the foot print by using key tables ect. ths came about because i was intermittently receving this error :
"Resource Governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase the memory of the Premium capacity where this dataset is hosted or reduce the memory footprint of your dataset by doing things like limiting the amount of imported data. More details: consumed memory MB, memory limit MB, database size before command execution MB. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159753.
Scheduled09/11/2022, 12:32:1209/11/2022, 12:52:42FailedThere was an error when processing the data in the dataset."
however i was sucsessfule in implementing data size reducing techniques and there refresh time became much better (and still is on destop and in worspace online) and for days i didnt recive this error. however a week ago i have the error occor again and repeat for every refresh be it on schedual or on demand all end in the same error afrer about 10 mins, previously the time betweeen refreshes when there were no errors and currently on the same report working on my workspace is around 2 mins.
this is not a large report maby 10mb ?
any ideas appreciated im going a bit mad
