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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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.