Forum Discussion

henryco88's avatar
henryco88
Icon for Helper II rankHelper II
6 years ago

Error change connection server from loclahost to server sql

Hi, I have a report connected to a localhost server. Now I would like to change the connection to a sql server which contains the same data and metadata of localhost. I clicked to "Transform Data" ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

Create a new query that points to the SQL server. Then do the same transforms as you did originally. Make sure both queries return the same columns as their final step.

 

If you can confirm that, grab the M code for the new query from Advanced Editor, and then replace the M code of the original query with the new code.