Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
danwscott
Frequent Visitor

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

‎10-22-2015 02:03 PM

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.

 

Labels:
Message 1 of 15
18,260 Views
0
14 REPLIES 14
lirim
Regular Visitor

‎09-16-2016 07:43 AM

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.

Message 14 of 15
6,703 Views
0
kiranmayiyl
Regular Visitor
In response to lirim

‎05-09-2017 01:21 PM

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.

 

Message 15 of 15
6,177 Views
0
arify
Microsoft Employee
Microsoft Employee

‎01-08-2016 10:59 AM

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

Message 13 of 15
7,013 Views
0
beedeagle
Frequent Visitor

‎12-24-2015 07:45 PM

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

Message 11 of 15
7,046 Views
0
dazhang
Microsoft Employee
Microsoft Employee
In response to beedeagle

‎12-28-2015 11:36 AM

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.

Message 12 of 15
7,030 Views
0
Sabya
Microsoft Employee
Microsoft Employee

‎11-23-2015 03:42 PM

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

Message 10 of 15
17,878 Views
0
dazhang
Microsoft Employee
Microsoft Employee

‎10-26-2015 01:53 AM

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?

Message 2 of 15
18,178 Views
danwscott
Frequent Visitor
In response to dazhang

‎10-26-2015 12:33 PM

Done.

Message 3 of 15
18,153 Views
0
Anonymous
Not applicable
In response to danwscott

‎10-29-2015 05:02 PM

Any luck? Same issue. Version 2.28.4190.122

Thank you!

Message 4 of 15
18,105 Views
0
dazhang
Microsoft Employee
Microsoft Employee
In response to Anonymous

‎10-29-2015 05:12 PM

We are currently investigating.

Message 5 of 15
18,103 Views
0
cwayne758
Helper IV
Helper IV
In response to dazhang

‎11-17-2015 10:06 AM

Any update? : OleDB.PNG

 

Thanks!

Message 6 of 15
18,053 Views
0
dazhang
Microsoft Employee
Microsoft Employee
In response to cwayne758

‎11-17-2015 02:23 PM

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.

Message 7 of 15
18,044 Views
0
v-sadadi
Microsoft Employee
Microsoft Employee
In response to dazhang

‎12-10-2015 10:17 PM

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

 

 

Message 8 of 15
17,918 Views
0
WillT
Community Admin
Community Admin
In response to v-sadadi

‎12-22-2015 04:01 PM
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
Message 9 of 15
17,839 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All