Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Power BI Architecture with Azure Analysis Service Different connection modes


We have around 50 power bi reports connected Live to On-Premise Analysis Services, and we are migrating to Azure Analysis Services.

When it was on premise it didn't matter if it was Live or import because we are were not charged by hour or throughput or data movement

But after migration I am confused which connection method I should select in order to achieve highest performance with least costs.

As far as I know, I can connect azure analysis service to DB by 2 methods: (Import or Live Connection)

and I can connect power bi to azure analysis service by 2 methods: (Import or Live connection)


Important Note that data is refreshed daily ( Not Real time data)


So I have some questions:


1. Analysis Services pricing is by hour, so If I am refreshing the model daily from DB, and let's say it takes 1 hour to process all the cubes, will I be charged 1 hour or 1 hour + all querying time that come from dashboard viewers when they access dashboard is live connection mode?


2. Is there an option to connect Azure Analysis service to the DB by import, and storing the data in the cube itself, and connecting power bi dashboards to this cube in live connection mode? ,, and how is the pricing calculated in this method?


3. Also since all the current dashboard that we have is live connection, is there any automatic way to make them import mode to the cube? I searched but couldn't find.


4. What is the best architecture for the semantic layer between Azure analysis service and power bi, knowing that power bi Premium capactiy is not an option in my company?






Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors