Bad error message

[artemus]

I tried to connect to a rights protected Excel file using 32-bit Power Bi and got this error:

Unable to connect

Details: "㽳㎁쟠ৣ堘痺埴痺"

I get different characters if I reopen Power Bi.

[v-qiuyu-msft]

Hi @artemus,

What do you mean about "a rights protected Excel file"? 

Please enable the desktop trace log, then repeat the steps to connect to Excel file again. Please check if any detail error message recorded in trace log. 

Best Regards,
Qiuyun Yu 

[artemus]

A right protected Excel file is one where the data classification is set to "Confidential" or "Highly Confidential"

If you want I can email you the error files, and the Excel file.

Here is one of the error messages (\r\n converted to newline):

{"Start":"2018-04-30T13:23:28.8129387Z","Action":"SimpleDocumentEvaluator/GetResult","HostProcessId":"44136","Exception":"Exception:
ExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Message: [DataFormat.Error] \u3F73\u3381\uC700\u09E3\u348C\u0975\uDA10w\u25D4\u09E3\u0121
StackTrace:
   at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderAce.ReadTables(IEngineHost host, BinaryValue workbook, Boolean useFirstRowAsHeader)
   at Microsoft.Mashup.Engine1.Library.Excel.ExcelModule.WorkbookFunctionValue.TypedInvoke(BinaryValue workbook, Value useHeaders, Value delayTypes)
   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
   at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args)
   at Microsoft.Mashup.Engine1.Runtime.FunctionValue.MetaTypeFunctionValue.Invoke(Value[] args)
   at Microsoft.Mashup.Engine1.Runtime.SerializationApplyingModule.SerializableFunctionValue.Invoke(Value[] args)
   at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction2.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
   at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(Value key)
   at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)
   at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
   at Microsoft.Mashup.Engine1.Runtime.FunctionValue.Invoke(Value[] args)
   at Microsoft.Mashup.Engine1.Language.InstructionInvocationInstruction.Execute(MembersFrame0& frame)
   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
   at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index)
   at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.ListValue.get_Item(Value key)
   at Microsoft.Mashup.Engine1.Runtime.Library.List.ElementWithListCheckFunctionValue.Invoke(Value collection, Value key)
   at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.Force(Int32 index)
   at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
   at Microsoft.Mashup.Engine1.Language.FieldAccessInstruction.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.Instruction.ExecuteCondition(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.DebugInstruction.ExecuteCondition(MembersFrame1& frame)
   at Microsoft.Mashup.Engine1.Language.IfInstruction.Execute(MembersFrame1& frame)
   at Micros","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"0fba423b-cc5e-4a39-87b1-387acf76009a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":51716,"Tid":1,"Duration":"00:00:00.0013666"}
DataMashup.Trace Warning: 24579 : {"Start":"2018-04-30T13:23:28.5764347Z","Action":"SimpleDocumentEvaluator/GetResult<IPreviewValueSource>","HostProcessId":"44136","Exception":"Exception:
ExceptionType: Microsoft.Mashup.Engine1.Runtime.ValueException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Message: [DataFormat.Error] \u3F73\u3381\uC700\u09E3\u348C\u0975\uDA10w\u25D4\u09E3\u0121
StackTrace:
   at Microsoft.Mashup.Evaluator.Interface.EvaluationResult2`1.get_Result()
   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass2.<BeginGetResult>b__0(EvaluationResult2`1 result)

InnerException
Exception:
ExceptionType: System.Data.OleDb.OleDbException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message: \u3F73\u3381\uC700\u09E3\u348C\u0975\uDA10w\u25D4\u09E3\u0121
StackTrace:
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at Microsoft.Mashup.Engine1.Library.Excel.ExcelReaderAce.ReadTables(IEngineHost host, BinaryValue workbook, Boolean useFirstRowAsHeader)

","ProductVersion":"2.57.5068.721 (PBIDesktop)","ActivityId":"0fba423b-cc5e-4a39-87b1-387acf76009a","Process":"Microsoft.Mashup.Container.NetFX40","Pid":51716,"Tid":1,"Duration":"00:00:00.2383159"}

[v-qiuyu-msft]

Hi @artemus,

You can upload error files, and the Excel file to your OneDrive and send the link via private message. 

Best Regards,
Qiuyun Yu 

[artemus]

I've sent a PM.

Just note: THis only happens on 32-bit version of PowerBi.

[v-qiuyu-msft]

Hi @artemus,

Do you mean the same workbook works with 64 bit Power BI desktop? I have tested with your Excel in both 64 bit and 32 bit desktop, both are not working. 

I guess the issue is related to Highly Confidential setting. Would you please remove this setting then test with 32 bit desktop? 

Best Regards,
Qiuyun Yu 

[artemus]

Yes, it works if I remove the privacy setting. In the 64-bit version it shows a meangiful error mesage due to other issues around needing the correct data acccessor.

My issue is that the error message is mangled. My issue is not in trying to load this dataset. I am concerned that this could be a security bug as it appears similar to a buffer overflow.

[v-qiuyu-msft]

Hi @artemus,

I tested again on my side with this Excel file, both in 32 bit and 64 bit versions, the same error throws out: 

I guess there might be some specific settings cause meaningless error message on your side. I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu