The expression references column which does not hold any data - Power BI Direct Query Error

[ctowery]

When adding a specific calculated column to a table visual in Power BI I receive the following error when I refresh the data.

The visual is fine upon initially dragging the calculated column over. Once I refresh the data I get the error. I'm using Direct Query with an Azure SQL Server.

[Anonymous]

Can you not add the calculated column as a part of the SQL Query? 

Ideally, you are not allowed to have calculated column in a direct query model.

[v-shex-msft]

Hi @ctowery ,

If you can please share some sample data for the test, it is hard to troubleshoot from your snapshot.

How to Get Your Question Answered Quickly  
Regards,

Xiaoxin Sheng