PowerBI Gateway Connections on SSAS Server

[vishalaj1]

Hi All,

We are connecting to On-Prem Instance of SSAS through Power BI Gateway.

We have observed that there are Multiple Connections from Power BI Gateway to our SSAS server when we are creating reports.

The connections are active after some time and are closed randomly.

We suspect if these are impacting the new connection request sent to SSAS instance.

Does anyone know anything about this?

Regards,

Vishal

[vishalaj1]

Hi All,

We are connecting to On-Prem Instance of SSAS through Power BI Gateway.

We have observed that there are Multiple Connections from Power BI Gateway to our SSAS server when we are creating reports.

The connections are active after some time and are closed randomly.

We suspect if these are impacting the new connection request sent to SSAS instance.

Does anyone know anything about this?

Regards,

Vishal

[GilbertQ]

Hi there

Are you creating the reports from the Power BI Service?

Either way I would assume that you have got multiple charts on a report sheet. So it would then be sending DAX queries for each of the visuals, due to the native cross-filtering feature.

I have not experienced any connection issues when using this in the past.

[vishalaj1]

Hi,

Thanks for your response.

Yes, the users are creating reports through service.

Also, they are selecting multiple charts, reports on dashboards.

Power BI connections were open even after 5 hours. So we were suspecting that this is the reason that new users were thrown out from ssas cubes even from excel pointing to ssas.

As it turned out there were users who were running import data from power bi desktop and it was taking up RAM.

Do we have any option to not allow import data or restrict users to not import huge data?

Cheers!

Vishal