How to connect azure analysis services with azure sql db for 250GB table size data?

Question

we have a view which generated around 250GB data and connected with power bi but the performance is bad. Now we are thinking to connect this view via azure analysis services and connect with power bi.

But when i see the pricing tiers there is no such tier to cache 250GB. Could anyone suggest me on this.

Answer 1

Azure Analysis service price tier S9 support you cache the 250GB data:

You could reference: Azure Analysis Services pricing

support Azure SQL database is Supported Data source in Azure Analysis Services :

How to connect azure analysis services with azure sql db ?

You can reference this tutorial:

1. Using Azure Analysis Services over Azure SQL DB and DW.
2. Creating your first data model in Azure Analysis Services

Create a sample data model to get data from Azure SQL database with SSDT or Visual Studio, then deploy the model to Azure Analysis Service. After the deployment finished, you could connect to the Azure Analysis Service from Power BI.

Hope this helps.