Forum Discussion
Failed to save modifications to the server - cannot even load/apply the simplest dataset
I've been working with Power BI both server and desktop for a while now, more than a year. Suddenly I can't get even the simplest dataset to load or an app that have been working earlier. Whenever I try to apply and load a dataset a command window for "SQLDUMPER" appears and I get the error message attached.
"Failed to save modifications to the server. Error returned: 'An unexpected exception occurred. A connection could not be made to the data source with the Name of ...."
I've tried several installs and reinstalls of power BI desktop, even on the secondary drive.
On this forum I've seen this case when it comes to Share point sources but it doesn't seem to apply in my case.
I've tried to change the timeout period in the options as stated in a response to the earlier posts on the forum without success.
I'm thinking that there is a recent installation for another application on the system messing with Power BI. Thinking that perhaps it's the local installation of SQL server but I've tried reparing that one also without success.
I can't interpret the logs to anything meaningful but if you like to try they're shared in this link together with the error message and the simplest possible app I've tried loading
7 Replies
I've been working with Power BI both server and desktop for a while now, more than a year. Suddenly I can't get even the simplest dataset to load or an app that have been working earlier. Whenever I try to apply and load a dataset a command window for "SQLDUMPER" appears and I get the error message attached.
"Failed to save modifications to the server. Error returned: 'An unexpected exception occurred. A connection could not be made to the data source with the Name of ...."
I've tried several installs and reinstalls of power BI desktop, even on the secondary drive.
On this forum I've seen this case when it comes to Share point sources but it doesn't seem to apply in my case.
I've tried to change the timeout period in the options as stated in a response to the earlier posts on the forum without success.
I'm thinking that there is a recent installation for another application on the system messing with Power BI. Thinking that perhaps it's the local installation of SQL server but I've tried reparing that one also without success.
I can't interpret the logs to anything meaningful but if you like to try they're shared in this link together with the error message and the simplest possible app I've tried loading
No I can work without a problem on different machines except from this specific one which is kind of a problem because it's my work machine. The example file is just to illustrate how simple reports I'm trying to load.
This problem just came from nowhere a month ago or so. Prior to that everything worked well.