Using Azure Analysis Service for Data Model

[varunaggarwal30]

Hi All,

I have created a data model inside power bi for a large organization. Currently , it supports all data limits and works fine. For scalability purpose, I am thinking to move the data model out of power bi. Now I can create a SSAS package and move to AAS package and connect power bi from there but there is lot of rework required for data mashup using SSIS. 

I am using SSDT with 1400 compatiblity and DataLake as my source. SSDT crashes at times and requires login information everytime when data refreshes. Anyone tried this process or is there a better way to work with ?

Thanks,

Varun Aggarwal

[v-qiuyu-msft]

Hi @varunaggarwal30,

You can follow this article to import Power BI data model to SSAS 2016 tabular. 

By the way, you can vote this idea: Import PowerBI Desktop model into SSAS Analysis Services Tabular. 

Best Regards,
Qiuyun Yu 

[varunaggarwal30]

@v-qiuyu-msft. I am able to load the model in SSAS and using SSDT can deploy it to Azure Analysis Services. My question is if we can automate the data refresh strategies once model deploys to AAS and considering the data source as ADLS. I tried to refresh the data but everytime it asks for credential to connect to data lake

[varunaggarwal30]

Hi All,

I have created a data model inside power bi for a large organization. Currently , it supports all data limits and works fine. For scalability purpose, I am thinking to move the data model out of power bi. Now I can create a SSAS package and move to AAS package and connect power bi from there but there is lot of rework required for data mashup using SSIS. 

I am using SSDT with 1400 compatiblity and DataLake as my source. SSDT crashes at times and requires login information everytime when data refreshes. Anyone tried this process or is there a better way to work with ?

Thanks,

Varun Aggarwal