cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
varunaggarwal30 Frequent Visitor
Frequent Visitor

Using Azure Analysis Service for Data Model

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

3 REPLIES 3
varunaggarwal30 Frequent Visitor
Frequent Visitor

Moving Data Model out of PowerBI

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

Moderator v-qiuyu-msft
Moderator

Re: Using Azure Analysis Service for Data Model

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
varunaggarwal30 Frequent Visitor
Frequent Visitor

Re: Using Azure Analysis Service for Data Model

@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