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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks v-yulgu-msft for your response.

 

When you mention: "You only need to set the refresh schedule for this single dataset, multiple data source will be refreshed."

Did you mean that, I need to only add the SSAS data source to the gateway and no need to add Azure SQL DB to the gateway?

 

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!