Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
danwscott
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
lirim
Regular Visitor

One of things that must be checked when this error is shown is Command Timeout.

 

It can be found under the Advance Options in configuring datasource.

I am getting this error after updating Power BI to May 2017 update. I did not have this issue earlier.

powerBI.PNG

I tried on a blank power bi project with out any older tables. 

My DB is an Azure Sql DB.

 

arify
Employee
Employee

Hi everyone, I implemented the fix, it should be available for you in the next Power BI release 🙂

 

Thanks for reporting this issue to us

Oguz

beedeagle
Frequent Visitor

I got the same error message when trying to import data from cube(mutildimension) with MDX. Any update?

Thanks to everyone who has reported this issue. The bug tracking this issue is still active, but lots of folks are on vacation till the end of the year so there hasn't been a lot of traction. Hopefully we will have an update in early January.

Sabya
Employee
Employee

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

dazhang
Employee
Employee

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?

Done.

Anonymous
Not applicable

Any luck? Same issue. Version 2.28.4190.122

Thank you!

We are currently investigating.

Any update? : OleDB.PNG

 

Thanks!

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.

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

 

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.