Forum Discussion

ctowery's avatar
ctowery
Helper I
6 years ago

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

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.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.