cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danwscott Frequent Visitor
Frequent Visitor

Receive Error: "Failed to save modifications to the Server."

I am attempting to create a dashboard (using PowerBI Desktop) that pulls data from a local server running Analysis Services Tabular (version 11.0.3000.0 )  I have successfully made reports from this particular tabular model (just earlier today), but this time I am attempting to run MDX against my tabular model.  My MDX is quite simple:

 

Select NON EMPTY [TimeDim].[Date].children on columns,

NON EMPTY TOPCOUNT([Class].[Class].children,10, [Measures].[Count]) on rows

from [Model]

where {([LogSource].[LogSource].&[Premier],[Measures].[Average Milliseconds])}

 

 

and runs just fine in SQL Server Management Studio.  It also returns results in PowerBI desktop.  However, when I click on the "Close and Apply" button in the Query Editor, I receive the error message above: "Failed to save modifications to the Server. Error returned: 'OLE DB or ODBC error: Object reference not set to an instance of an object..'."

 

Wondering if this could be related the cause of the problem in this previous thread: Cannot Post from Power BI Desktop and what the solution is.

 

14 REPLIES 14
Microsoft dazhang
Microsoft

Re: Receive Error: "Failed to save modifications to the Server."

What version of Power BI Desktop are you running? Would you be able to enable tracing (File, Options and Settings, Options, Diagnostics, Enable tracing), run your scenario and send a frown to us with the traces attached?

danwscott Frequent Visitor
Frequent Visitor

Re: Receive Error: "Failed to save modifications to the Server."

Done.

alexdurok Regular Visitor
Regular Visitor

Re: Receive Error: "Failed to save modifications to the Server."

Any luck? Same issue. Version 2.28.4190.122

Thank you!

Microsoft dazhang
Microsoft

Re: Receive Error: "Failed to save modifications to the Server."

We are currently investigating.

cwayne758 Member
Member

Re: Receive Error: "Failed to save modifications to the Server."

Any update? : OleDB.PNG

 

Thanks!

Microsoft dazhang
Microsoft

Re: Receive Error: "Failed to save modifications to the Server."

We are still investigating the "Object reference not set to an instance of an object" issue. However, the error message "The provider 'Micorsoft.PowerBI.OleDb' is not registered." is an unrelated issue - it looks like your Power BI Desktop installation is corrupt. I believe you also send a frown on this; we will follow up with you on that.

Microsoft Sabya
Microsoft

Re: Receive Error: "Failed to save modifications to the Server."

Facing the same issue when connecting the SSAS and loading the data executed from MDX query against my cube. Do we have resolution for it ?

Thanks for all the help!

 

Additional Information :  I enabled the trace - Trace file looks like -

DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:16.5915254Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.0108186"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:17.4632827Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.0001614"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:17.4730860Z","Action":"Engine/IO/AnalysisServices/ConnectionFactory/CreateConnection","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.0489167"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:17.5234815Z","Action":"Engine/IO/AnalysisServices/Connection/Open","ServerVersion":"12.0.4100.1","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.3197884"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:17.8470136Z","Action":"Engine/IO/AnalysisServices/Command/ExecuteReader","CommandBehavior":"CloseConnection","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.2787967"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6270333Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0009675"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6280521Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0004452"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6289746Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0009528"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6324850Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","Exception":"Exception:\r\nExceptionType: System.IO.FileNotFoundException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Could not find file 'C:\\Users\\v-sabyak\\AppData\\Local\\Microsoft\\Power BI Desktop\\Cache\\Index\\51D93FD3F2A0CE07.idx'.\r\nStackTrace:\n at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)\r\n at Microsoft.Mashup.EngineHost.Services.DiskPersistentCache.PersistentDictionary.<>c__DisplayClass24.<ReadBucket>b__23()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, Nullable`1 activityId, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0040559"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6370131Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0056163"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6426740Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0005246"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.6432381Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0010906"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.7840110Z","Action":"SimpleDocumentEvaluator/BeginGetResult<IDataReaderSource>/callback","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.0026944"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:16.8274338Z","Action":"SimpleDocumentEvaluator/BeginGetResult<IValue>","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:05.9593028"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:16.7925275Z","Action":"FirewallDocumentEvaluator/BeginGetResult","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:05.9943039"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.7937685Z","Action":"Engine/IO/AnalysisServices/ConnectionFactory/CreateConnection","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.0000726"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.7938909Z","Action":"Engine/IO/AnalysisServices/Connection/Open","ServerVersion":"12.0.4100.1","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.1349528"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:22.9289724Z","Action":"Engine/IO/AnalysisServices/Command/ExecuteReader","CommandBehavior":"CloseConnection","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":1,"Duration":"00:00:00.2474158"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6167227Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0001444"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6169154Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0003023"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6172758Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0007389"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6181075Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","Exception":"Exception:\r\nExceptionType: System.IO.FileNotFoundException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Could not find file 'C:\\Users\\v-sabyak\\AppData\\Local\\Microsoft\\Power BI Desktop\\Cache\\Index\\DEDEFB72ED0DCBB0.idx'.\r\nStackTrace:\n at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)\r\n at Microsoft.Mashup.EngineHost.Services.DiskPersistentCache.PersistentDictionary.<>c__DisplayClass24.<ReadBucket>b__23()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.<>c__DisplayClass4.<IgnoringAccessExceptions>b__3()\r\n at Microsoft.Mashup.EngineHost.Services.FileSystemAccessHelper.TryIgnoringAccessExceptions[T](Func`1 func, Nullable`1 activityId, T& result, Exception& accessException)\r\n\r\n\r\n","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0003311"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6184521Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0028227"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6213171Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0002463"}
DataMashup.Trace Information: 24579 : {"Start":"2015-11-23T23:34:27.6215812Z","Action":"FileSystemAccessHelper/TryIgnoringAccessExceptions","ProductVersion":"2.28.4190.122 (Stabilization)","ActivityId":"9cb6863e-fd86-45db-9707-32e2b01d6ccf","Process":"Microsoft.Mashup.Container.NetFX40","Pid":8484,"Tid":5,"Duration":"00:00:00.0006465"}
DataMashup.Trace Warning: 24579 : {"Start":"2015-11-23T23:34:22.7885481Z","Action":"RemotePageReader/RunStub","Exception":"Exception:\r\nExceptionType: System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Object reference not set to an instance of an object.\r\nStackTrace:\n at System.Object.GetType()\r\n at Microsoft.OleDb.ObjectColumn.AddValue(Object value)\r\n at Microsoft.OleDb.NullableColumn.AddValue(Object value)\r\n at Microsoft.OleDb.Serialization.DataReaderPageReader.ObjectPage.SyncColumnsPage()\r\n at Microsoft.OleDb.Serialization.DataReaderPageReader.ObjectPage.GetColumn(Int32 ordinal)\r\n at Microsoft.OleDb.Serialization.PageWriter.WritePage(IPage page)\r\n at Microsoft.OleDb.Serialization.OverlappingPageWriter.PageSerializer(Object obj)\r\n\r\n\r\n","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Object reference not set to an instance of an object.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__1(Exception exception)\r\n at Microsoft.OleDb.Serialization.OverlappingPageWriter.CheckException()\r\n at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Object reference not set to an instance of an object.\r\nStackTrace:\n at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__1(Exception exception)\r\n at Microsoft.OleDb.Serialization.OverlappingPageWriter.CheckException()\r\n at Microsoft.Mashup.Evaluator.RemotePageReader.<>c__DisplayClass7.<RunStub>b__0()\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n at Microsoft.Mashup.Evaluator.RemotePageReader.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPageReader)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass32`1.<OnBeginGetResult>b__2f()\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)\r\n at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetDataReaderSource(IMessageChannel channel, BeginGetDataReaderSourceMessage message)\r\n at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)\r\n at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)\r\n at Microsoft.Mashup.Evaluator.EvaluationHost.Run()\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)\r\n at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass15.<CreateAction>b__14(Object o)\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)\r\n at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)\r\n\r\nInnerException\r\nException:\r\nExceptionType: Microsoft.Mashup.Evaluator.Interface.ErrorException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: Object reference not set to an instance of an object.\r\nStackTrace:\n at System.Object.GetType()\r\n at Microsoft.OleDb.ObjectColumn.AddValue(Object value)\r\n at Microsoft.OleDb.NullableColumn.AddValue(Object value)\r\n at Microsoft

Microsoft v-sadadi
Microsoft

Re: Receive Error: "Failed to save modifications to the Server."

Hi Team,

 

I tried connecting to SSAS Tabular Model using Power BI Desktop. I have chosen Import from Model and have written a DAX query to filter the data. I am getting the below error when I try to load the query.

 

Query:
EVALUATE
(
FILTER
(
'Dashboard',
Dashboard[LoginId] = USERNAME()
)
)

 

"Failed to save modifications to the Server. Error returned: 'OLE DB or ODBC error: Object reference not set to an instance of an object..'."

 

Any help on this issue is highly appreciated.

 

Thanks

Satya

 

 

Moderator WillT
Moderator

Re: Receive Error: "Failed to save modifications to the Server."

Hi everyone - if you're hitting error messages like this, it could be a bug so please report it through the Send A Frown. This is the best way to help us debug and fix the problems! Thanks

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,858)