Forum Discussion
PowerBI Gateway Connections on SSAS Server
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 creat...
GilbertQ
Super User
Super UserHi 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.
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.
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