Forum Discussion
Benjosh
5 years agoHelper I
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.
aj1973
5 years agoCommunity Champion
What Power Bi has to do with this!?
- Benjosh5 years agoHelper 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.
- aj19735 years agoCommunity 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.