Query editor, building table preview takes infinite time

[AlexeyRusinov]

Hello everyone,

I'm building quite a big data model from a complex CRM Online data source, which requires a lot of table editing, merging, etc. Starting frm yesterday I started to notice that I cannot see tables preview anymore. It just keeps loading all the time, and nothing happens. However, when I click "Apply Changes", it takes some time but loads successfully.
What could be the probably cause of preview freezing?

UPDATE: also problems when adding a custom column now, it just keeps thinking for infinite...

[vanessafvg · Accepted solution]

in your file/options and settings / options

have you played with these at all?  not sure what the impact will be if you untick the allow data to preview in the background?

[AlexeyRusinov]

@vanessafvg Thank you very much. I've unticked two last options, and that do the trick. Preview is loading slowly, but stable every time.

[IgorGershenson]

I followed these steps but my preview is still not showing up. How long does it take for you?

[DirkS]

In case it still helps anyone: deleting the cache worked for me.