Power Bi desktop or SSAS

[hector3315]

I have been working with power bi desktop, we did an inform and I'm thinking on change to an SSAS because the machine where we ran the pbi Desktop ran out of memory wen we get the real data. And we think that SSAS would be a solution.  What do you think ?

I want to know too if I can connect my sql server database in live with SSAS I mean if I insert something in de database it will be inserted too at the same time in SSAS.

Thanks for the answers

[v-qiuyu-msft · Accepted solution]

Hi @hector3315,

>>I have been working with power bi desktop, we did an inform and I'm thinking on change to an SSAS because the machine where we ran the pbi Desktop ran out of memory wen we get the real data. And we think that SSAS would be a solution.  What do you think ?

The Query Editor and Realtionship features in Power BI desktop can also be done on SSAS side. You can create a SSAS cube, then connect to it in desktop in a live connetcion.

>>I want to know too if I can connect my sql server database in live with SSAS I mean if I insert something in de database it will be inserted too at the same time in SSAS.

As far as I know, if you update data in orignal database which cube build from, you need to re-process the project to make the updated data into the cube. As the issue is more related to SSAS, you can post a thread in SQL Server Analysis Services forum.

Best Regards,
Qiuyun Yu

[Anonymous]

Hi hector3315.

You can create a tabular model (cube) in SSAS to aggregate the data instead of doing it in PowerBI for sure.

And then do a directquery against the model from PowerBI.

Which version and edition of SQLServer are you using by the way? 

The SSAS model won't automatically be updated when you insert data into your underlying tables - unless the model is set up with DirectQuery as well. However, you can set up a job that processes the SSAS model whenever you insert data into the tables.

SSIS and SQLAgent jobs is the easiest way to accomplish this in my experience.