Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Changing data source connection

I am doing migration work that requires changing a dataset connection from one SQL Server to another. When I go to trasnfomr data and data sourec settings I see this (Below)   Can anyone heL...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hi! To swap from one semantic model to another you need to make sure you have access to the new one. When you click Datasource settings in Transform Data the window that opens shows all of the models that you have access to connect to. If you do not see it listed you need to request the correct access. Once you see the semantic model that you want to change to available, simply click on it and click Connect.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

HI,

 

Thanks but it is connected via a live semantic model so I cannot access the tranformation steps.

 

I may be wrong when I said its a SQL Server connection but we use Microsoft Anaklysis Services compones to do data modelling and use power bi just for teh reproting.

 

Thanks 

  • audreygerred's avatar
    audreygerred
    Icon for Super User rankSuper User
    2 years ago

    Hi! To swap from one semantic model to another you need to make sure you have access to the new one. When you click Datasource settings in Transform Data the window that opens shows all of the models that you have access to connect to. If you do not see it listed you need to request the correct access. Once you see the semantic model that you want to change to available, simply click on it and click Connect.