Has anyone had experience with Azure Analysis Services hosting models for Power BI?
So, I'm in a weird project. The company I'm working has 6 distinct servers on AAS hosting models for Power BI reports, some reports are Imports but some use Live Connection, and I cannot understand what its the advantage of having an infrastructure like this.
My current project is to reduce the cost that this servers are generating (all of them are in the price tier S4).
Besides that the refresh process for these servers is a mess. Its all through runbooks that have a million different schedules. The Live Connection reports compete for the resources of the server when they are in use and generate a lot of memory issues on a capacity that is already fairly high.
I'm here trying to come up with a plan, but this seems so complicated. I've not personally worked with AAS before. So my first instinct is to convert all these "live connection" reports to imports, they refresh like 3 times a day with the runbooks, there is no "real time" data or anything.
How would you approach this issue?