Forum Discussion

hector3315's avatar
hector3315
Frequent Visitor
9 years ago
Solved

Power Bi desktop or SSAS

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 t...
Need Help
Show and Tell
Tips and Tricks
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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