cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hector3315
Frequent Visitor

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 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 Smiley Very Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Power Bi desktop or SSAS

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
JohanLudvig
Frequent Visitor

Re: Power Bi desktop or SSAS

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.

Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Power Bi desktop or SSAS

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors