Forum Discussion

adclabby's avatar
adclabby
New Member
1 year ago

Error Fetching Data for this visual

I am in the process of rebuilding a report and seem to have run into another issue. I created a calculated column that sums the total currency of three other columns, and when I try to include it into my table I have the following error. Anyone encountered this before or know why this is happening? Thanks

 

4 Replies

  • Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

    • adclabby's avatar
      adclabby
      New Member

      I have never received this error before so it is new to me, I am unsure how to solve it so I am stuck because my visual will not display my data correctly. Any advice on how to troubleshoot this problem or an explanation as to what it means or why it is happening would be amazing.

      • lbendlin's avatar
        lbendlin
        Super User

        It mentions a column name. Can you identify the code in your calculated column that references it?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi adclabby ,

     

    I agree with lbendlin. According to the error, it seems that your issue was caused that Power BI couldn't find the column 'CPO Total'. 

    Please make sure whether you changed the name of it or remove it in Power Query Editor. This will cause Power BI couldn't find it and show error.

    You can check the calculated column which sums these columns. I think the red wavy line is displayed below 'CPO Total' column.

     

    Best Regards,
    Rico Zhou

     

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