I have a simple DAX measure which looks like this:
Total = [Calls] + [Meetings]
The two parts [Calls] and [Meetings] are themselves measures and there is a bit of a dependancy tree but ultimately they are summing columns from the same underlying table which is Direct Query to the MS Teams Call Quality Connector, the rest of the model is in import mode. There is one many to many relationship from this table. I am running on Power BI Premium.
To test this I have split up the calculation and executing the queries in SSMS. I have this code:
EVALUATE {
VAR a = [Meetings]
VAR b = [Calls]
VAR c = a + b
Return c
}
If I reurn variable a I get a number, if I return variable b I get a number. If i return variable c I get this error:
Executing the query ...
<ccon>Expression.Error: <ccon>3</ccon> keys were specified, but <ccon>2</ccon> values were provided.. <ccon>{error "Microsoft.Mashup.Engine1.Runtime.ValueException: [Expression.Error] Value was not specified.#(cr)#(lf) at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForNotImplemented(INotImplementedExpression expression)#(cr)#(lf) at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)#(cr)#(lf) at Microsoft.Data.Mashup.ProviderCommon.MashupResource.TryGetValue(Func`1 getValue, IValue& value, String& errorMessage)#(cr)#(lf)Record"}</ccon>. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Technical Details:
RootActivityId:
Date (UTC):
0: PFError::SetLastError() line 2649 + 0x0 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
1: PFSetLastError() line 3348 + 0x0 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
2: ConvertExceptionsToPFResult<<lambda_d359256228571b4b16c28b1cea323c28> >() line 393 + 0x34 (Sql\Picasso\Engine\src\pf\kernel\shared\pfshmacros.inl)
3: PFSetLastErrorExTag() line 3943 + 0x21 (Sql\Picasso\Engine\src\pf\eh\pferror.cpp)
4: 0x00007FF975A63EBE (symbolic name unavailable)
Run complete
