Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Error fetching data for this visual

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.

General Comment

3 Replies

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Super User
    1 year ago

    Anonymous 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous ,

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.