1

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.

Pradeep Kaja
  • 115
  • 1
  • 16
  • 1
    Did you do an import in Power BI or direct query? Also you don't store all 250 GB it will be highly compressed. I would suggest building the model in SSDT and seeing how large it is in memory before getting AAS setup. – cbattlegear Dec 23 '19 at 15:47

1 Answers1

0

Azure Analysis service price tier S9 support you cache the 250GB data: enter image description here

You could reference: Azure Analysis Services pricing

support Azure SQL database is Supported Data source in Azure Analysis Services : enter image description here

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.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23
  • Just as a heads up, S9 isn't available in all regions. Someone else suggested to load the model and see how big it is. AS does compress the data. Finally, keep in mind that if you process the model you need some memory overhead for the model to fully process. – all2neat Jan 17 '20 at 18:46