Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Multiple data source SASS Cube and SQL azure DB

Hi All   I need to import data from multiple data source: 1. on-premises SSAS 2. Azure SQL DB   Also, I would need to create relationships between the two and hence would import the data instea...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi Anonymous,

     

    Sorry for my confused reply. 

     

    Since you combined SSAS and SQL Azure DB in a single dataset, to set schedule refresh for data source, you need to add gateway for both SSAS and Azure SQL DB.

     

    Regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

Sorry for my confused reply. 

 

Since you combined SSAS and SQL Azure DB in a single dataset, to set schedule refresh for data source, you need to add gateway for both SSAS and Azure SQL DB.

 

Regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks v-yulgu-msft , this answers my question!