My SSAS settings are fine. Set to 90% on a 32 GB server machine. Still get the same error.
I have only a couple of calculated columns, but I have lot of visualizations and measures dependent on them. Does that mean, everytime I have to add new columns to the query from the source or refresh the dataset in Desktop, I need to delete all the data prep steps and re-do them?
Anyways, it doesn't work either. Get the same error even after removing all the calculated columns and other data prep steps.
This is very weird. How much memory does Importing from SSAS need? Doesn't make sense. Both Live connection and full process of model on SSAS server work fine.