Forum Discussion

Benjosh's avatar
Benjosh
Helper I
5 years ago

Spark Vs SSAS Tabular

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.

3 Replies

    • Benjosh's avatar
      Benjosh
      Helper I

      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's avatar
        aj1973
        Community Champion

        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.