cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Number of mashup engine containers

Hello everybody,

 

After the January gateway update (https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-january-update-is-now-available/) and the possibility of controlling the number of mashup engine containers I have trouble figuring what applies to my circumstances, which are:

 

- I currently develop reports against SSAS tabular models through live connection.

-These models are deployed in an Azure machine; let's call it A.

-My on-premises data gateway is installed on another Azure machine which only holds an SSIS instance; lets call it B.

-My published Power BI reports connect to A through B gateway.

 

My question is this: if I tweak the number of mashup engine containers, will it affect the resources of A or B? B is the one with the gateway installed, but it will be A resources the ones used to query the different models and answer the viewer's demands.

 

Also, A and B don't have the same amount of cores, so I don't know which number I must employ as guidance to establish the MashupDefaultPoolContainerMaxCount value as the article says.

 

 

Thank you very much in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

@l2aFa,

When you tweak the number of mashup engine containers, it will require B’s resources and affect your machine B’ s performance. In your scenario, if you only have live datasets, the On-Premise Gateway will act as in a pass along mode, passing the data to the source, getting the results and passing it back to the Power BI Service, the query will be executed at the source side(Machine A). In this case, I don’t think you have to change the “MashupDefalutPoolConainerMaxCount” setting as there are no queries running or data model at gateway side.

However, if you persist to change number of mashup engine containers , as the blog says, a recommended ceiling for the maximum number of containers you can use is roughly twice the number of cores in your local machine(B) processor.

Regards,
Lydia

Community Support Team _ Lydia Zhang
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
Highlighted
Microsoft
Microsoft

@l2aFa,

When you tweak the number of mashup engine containers, it will require B’s resources and affect your machine B’ s performance. In your scenario, if you only have live datasets, the On-Premise Gateway will act as in a pass along mode, passing the data to the source, getting the results and passing it back to the Power BI Service, the query will be executed at the source side(Machine A). In this case, I don’t think you have to change the “MashupDefalutPoolConainerMaxCount” setting as there are no queries running or data model at gateway side.

However, if you persist to change number of mashup engine containers , as the blog says, a recommended ceiling for the maximum number of containers you can use is roughly twice the number of cores in your local machine(B) processor.

Regards,
Lydia

Community Support Team _ Lydia Zhang
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

Highlighted

Thank you very much for your answer Lydia, I will have this in mind.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors