Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change data source from Mongo DB to Azure Sql DB

Hi,   I have built some of the reports with pointing to Mongo DB. Now I want to change the source to Azure Sql DB, so that I do not need to build the reports again ?   When I try to change the da...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous you can easily achieve this by changing source in advance query editor. So create a sample table using new sql server, go to edit query, and choose advanced editor on new sql server table. Copy source and navigation line from this table and copy to other tables in your model.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous you can easily achieve this by changing source in advance query editor. So create a sample table using new sql server, go to edit query, and choose advanced editor on new sql server table. Copy source and navigation line from this table and copy to other tables in your model.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for the solution. It worked.

     

    I have a question. Typically If I want to change data source and publish to respective workspace considering both DB's are Azure SQL DB's, Would just changing the source work ? I mean there is no need of doing the datamodelling, derived columns, measures again after changing the data source. Is this correct ?