Error fetching data for this visual

[calcstuff]

My Power BI table visual is working fine. When I go to rename a column with "rename for this visual" the table breaks and I get the error "Query (13, 4) The column 'Last Date' specified in the 'SUMMARIZE' function was not found in the input table.". How do I fix this? The 'Last Date' column contains null values if that matters.

[Anonymous]

Hi @calcstuff ,

Could you please provide more information here to help us reproduce the issue?

1. Select Performance analyzer under Optimize:

2. Refresh the visual and Run in DAX Query View

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[calcstuff]

I renamed the table in the front end and that's when the table breaks. I went in and changed my NULL dates to dummy dates and that "fixed" the issue of the broken table visualization. But now the logic of my whole report needs to change. I think that my DAX that used these NULL dates had some type of issue with the NULLs, but I'm not sure. This is a tedious process trying to figure out what is going on.

[Jai-Rathinavel]

@calcstuff did you rename the column at power query level ? If yes, revert the changes and rename the column in the frontend by double clicking on it