cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hector3315 Frequent Visitor
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
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
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.

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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors