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

Migrating report from SSAS Cube to azure synapse

I'm fairly new to cloud as well as to the power BI. Was trying to understand which steps do i need to make in order to migrate reports from SSAS cube (all data for the reports is on-prem) to azure synapse. My guess is that my company wants me to do it though dedicated pipelines. Does it mean that after I send it from dev to test environment though the pipeline I need to change my source connection to azure one? 
 Thank you in advance 

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Kolyckaa ,

 

Based on your description, this seems to be feasible. Refer to the following process for the specific relocation.

vhenrykmstf_0-1642384708297.png

 

Note that the Azure VM deployment with SSAS running in the Azure region of the Power BI tenant is required. And the SSAS VM needs to be added to the organization's Active Directory environment, etc. before moving SSAS to Azure VM.

For more details, you can read related blog as below.

Moving on-premises AS and RS BI solutions to Azure – and closer to Power BI | Microsoft Power ...


If the problem is still not resolved, please point it out. Looking forward to your feedback.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-henryk-mstf
Community Support
Community Support

Hi @Kolyckaa ,

 

Based on your description, this seems to be feasible. Refer to the following process for the specific relocation.

vhenrykmstf_0-1642384708297.png

 

Note that the Azure VM deployment with SSAS running in the Azure region of the Power BI tenant is required. And the SSAS VM needs to be added to the organization's Active Directory environment, etc. before moving SSAS to Azure VM.

For more details, you can read related blog as below.

Moving on-premises AS and RS BI solutions to Azure – and closer to Power BI | Microsoft Power ...


If the problem is still not resolved, please point it out. Looking forward to your feedback.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.