Forum Discussion

tessahurr's avatar
tessahurr
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.   ...
General Comment
maksimk's avatar
maksimk
New Member
5 years ago

Hi,

 

I tried to create a variable using the data from DirectQuery data source and I'm faced with the error:

"An unexpected error occurred (file 'xldqas.cpp', line 503, function 'DAXDefManager::AddVariableOrInlineExpr')."

 

Measure I used (here 'Average Story Points' is data source connected using DirectQuery):

Estimates = IF('Release Scope'[Story Points] = BLANK(),

VAR AverageBugVelocity = LOOKUPVALUE('Average Story Points'[Bug Story Points Average], 'Average Story Points'[Team], 'Release Scope'[Team])

RETURN

SWITCH(

'Release Scope'[Issue Type],

"Bug", AverageBugVelocity,

0),

'Release Scope'[Story Points])