I am using SSAS Tabular in Visual Studio 2017 against a SQL Server instance (Compatibility 1200)
I have a relatively small query (<1 M rows) that executes fully in 8 seconds in the database. Pulling it into SSAS during design time takes a few extra seconds to transfer the data, but still maybe just a minute or two.
Deployment is fine - never been any problems whatsoever.
Every "query timeout" setting I can find in SSAS is set =0, which should indicate no timeout.
HOWEVER.... in SSAS design mode in Visual Studio, when I try to view the properties for this table to add a couple new columns, the "Preview" bombs out after 30 seconds and tells me the query timed out. When I try to view the properties for the Partitions, the same thing happens. No matter what I do, it will not let me make any new modifications, citing this error: "Failed to retrieve data from dbo.vw_DataView. Reason: Query timeout expired"
Where is the setting for this? Everything I find online tells me to change the query timeout settings, but mine are set to the default, which is no timeout!
Also, can I limit the data preview? I liked multi-dimensional SSAS design-mode better, where you did not have to preview the data unless you wanted to. This silly preview "feature" in Tabular simply eats up all my the RAM on my laptop for no reason. It would be okay if it just "previewed" the top 200 rows, but it doesn't do that. I haven't found any helpful documentation on this.