Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Calculated Columns don't work in Power BI with Azure Analysis Services in DirectQuery Mode

- I am using Azure Anlysis Services in DirectQuery mode.

- I have created a Calculated column. This column definitely has data because when I am performing summation over it, a number appears in the measure.

- After I deploy my model, it appears as a field in Power BI. When I try to create a visualization from it, it gives the error:
The expression referenced column 'DimDate'[Previous Week] which does not hold any data because it needs to be recalculated or refreshed.

 

I think Calculated Columns are not supported in DirectQuery mode from Azure Analysis Services?

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @ptewary

 

Please create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

EmielvdR
Frequent Visitor

@ptewary please check the model for errors (e.g. connect with tabular editor). Deployment can be done even if there are (unsupported) functions used in the model. Tabular editor will show these errors.