Refresh fails UNLESS first previewing each table in Transform Data

Hi,

a) I am not doing the refresh on PBI Service.  Instead I am doing the refresh in PBI Desktop.  I only use PBI Service to publish the dataset after refresh and let the users consume the visuals from there.

b) I am using the Oct 2022 release - ver 2.110.1161.0 64 bit

c) The issue still exist.  When I refresh WITHOUT going into Tranform Data and previewing each table / query, I receive the following error on one of the main transformed tables 'QUERY / TABLE NAME (step 'xxxx') referneces other queries or steps, so it may not directly access a data source.  Please rebuild this data combination."  However, if I first go into Transform Data, preview each table / query, and then Close or Close and Apply, and then refresh I do not receive the error and all works fine.  Again, nothing has changed since the last refresh other than I have new, updated CSV data source files (no change in columns or column names, just updated data).

Note: The transformation queries I have are extensive with many steps as I shape the source data for loading into the model, so I recognize the refresh is extensive and a heavy load.  However, I can not determine why I need to do the preview steps so that PBI "remembers" how to do this from the previous time I refreshed.

Note: from the earlier solution, I did increase the Maximum Allowed (MB) setting under Data Cache Management Options from 4096 to 8192.  This did not solve the problem as it still occurs as noted above.

Any thoughts on where to look next to identify the problem or potential solutions?

Regards,