Forum Discussion

mbd's avatar
mbd
Helper I
8 years ago
Solved

Data Source Change

I've created many reports using data from a database located on Azure. I need to change my data source to an updated database. The old and new database are both in Azure. The new database has some ad...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Create a new query that connects to the new data source. Go into Advanced Editor in the Query Editor and copy the Source line. Then, edit your other queries and replace their Source lines.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Create a new query that connects to the new data source. Go into Advanced Editor in the Query Editor and copy the Source line. Then, edit your other queries and replace their Source lines.

mbd's avatar
mbd
Helper I
8 years ago

When I went into the Advanced Editor in the Query Editor the Source line is already pointing to the correct source. I had already changed the source using Data Source Settings and it changed all the queries to the new data source. 

 

I should have added that even though the queries are all pointing to the new data source, the reports are not updating when I refresh.

 

 Final solution. I had a friend who knows SQL take a look and he helped me change the SQL code in the Advanced Editor in the Query Editor. I know the step I missed was not creating a new query as you stated. I just used the Data Source Setting in the Query Editor.