Spark Vs SSAS Tabular

[Benjosh]

I came across that both Spark & SSAS Tabular run on In-Memory processing & like to know which to choose when my working big data & my SSAS is always running into 100% memory usage.

[aj1973]

What Power Bi has to do with this!?

[Benjosh]

@aj1973 Hi Friend,

My data source of Power BI is SSAS Tabular model. Without Data I have nothing to do with Power BI

If my data source has an issue I cannot work with Power BI 

So I want a suitable model (db) for my Power BI 

& my current SSAS data source (dedicated server for Power BI) is showing 100% memory usage most of the time.

[aj1973]

Yes I see,

Well for sure memory usage for SSAS needs to be optimised, however have you tried to use only the tables that you need for your report into Power bi Desktop? those tables might not be involved in the Memory usage of SSAS. Try it, maybe you will get what you need until SSAS is optimised.