Forum Discussion
Old sql db is dropped. How to repoint the current data source to new db on the same sql server
Our old sql server db has been dropped. How to repoint the existing data source to the new db from the same sql server?
The database field is grayed out. Do I have to create a new datasource from scratch then delete the old one? We are using power BI from cloud connect through on-premises data gateway.
Also question about the 'Username' field, Is it a sql server db user or an admin sign-in like 'username@.....' (email)? the person who set it up has left.
After I created new data source, do I need to refresh all the connections from every report?
Hi. Yes you need to add a new data source and if you want you can delete the old one. Regarding the "username" it depends on the authentication. For example the "basic" it's a sql server user like user= "sa" , but you can pick windows user or active directoy in case you have one of those connections.
After creating the new source just open a schedule refresh of one of the datasets connected and check gateway settings. The connection would be found automatically if you have input the data exactly as the Desktop dataset was published. If not, you need to map it in that menu.
You might need to schedule the refresh time for all the reports again. So you can check it there.I hope that helps,
3 Replies
- ibarrau
Super User
Hi. Yes you need to add a new data source and if you want you can delete the old one. Regarding the "username" it depends on the authentication. For example the "basic" it's a sql server user like user= "sa" , but you can pick windows user or active directoy in case you have one of those connections.
After creating the new source just open a schedule refresh of one of the datasets connected and check gateway settings. The connection would be found automatically if you have input the data exactly as the Desktop dataset was published. If not, you need to map it in that menu.
You might need to schedule the refresh time for all the reports again. So you can check it there.I hope that helps,
hi ibarrau, your reply is so helpful. This is exactly what I am looking for. Many thanks
hi your answer is so helpful. This is what we are looking for.
