Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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.
I tried on a blank power bi project with out any older tables.
My DB is an Azure Sql DB.
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
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.
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
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.
Any luck? Same issue. Version 2.28.4190.122
Thank you!
We are currently investigating.
Any update? :
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |