Showing results for 
Search instead for 
Did you mean: 
cheidemann New Member
New Member

SSAS with Direct Query and Calculated Columns



When I add a calculated column to the Report, that I have did on SSAS Model, I'm getting this error :
The expression referenced column 'alarms'[HourOfDay] which does not hold any data because it needs to be recalculated or refreshed.


I have tried add more calculated columns and the same error shows for the visualizations that is using a calculated column.


Looks like Power BI doesn't support models with calculated columns and DirectQuery enabled.


Can someone confirm that ?



Tabular Model 

Compatibility Level: SQL Server 2017 / Azure Analysis Services (1400)

DirectQuery Mode: On



Best regards,






Community Support Team
Community Support Team

Re: SSAS with Direct Query and Calculated Columns

Hi @cheidemann ,

I'm sorry that I don't have the test environment for Azure Analysis Services.

In addition, I'm afraid that there are only two ways (import and Connect live) for us to connect the Azure Analysis Services Database in Power BI Desktop.

For you error message, please try this ways below.

1. Refresh the data source after you connecting the data in Power BI Desktop.

2. Save the pbix after loading the data and open it again to check if the issue will be fixed.

Besides, please check if you have installed the latest version of Power BI Desktop 2.68.5432.841.

Best  Regards,



Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mpozgaj New Member
New Member

Re: SSAS with Direct Query and Calculated Columns

Hello @v-piga-msft 


I'm working with @cheidemann on the same project.


SASS and DirectQuery is working for us with regular columns, but the calculated ones are broken.

The issue is only with calculated columns.