Getting error in while refreshing the dashboard

[shaik1]

Dear team,

I am facing error while refreshing the dashboard getting error.

Expression.Error: The column 'Business Team' of the table wasn't found.
Details: Business Team

I have checked in Power bi replace value showing error. Data source used excel. Kindly help on this.

Thanks in advance

[burakkaragoz]

Hi @shaik1 ,

The error you're seeing usually means that the column "Business Team" doesn't exist at the step where you're trying to use it. A couple of things to check:

1. Check the step order in Power Query — maybe the column was renamed or removed in a previous step.
2. If you're trying to add the "Business Team" column using Table.AddColumn, make sure you're not referencing it before it's created.
3. Also, in your condition:

   if [#"Job Title"] = "Sales Advisor" and [#"Job Title"] = "Sales Advisor"

You might want to double-check that logic — looks like it's repeating the same condition twice.

Try reviewing the steps in the Applied Steps pane and see where "Business Team" is first introduced or referenced.

Let me know if you can share more about the query steps — happy to help further.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI

[v-dineshya]

Hi @shaik1 ,

Thank you for reaching out to the Microsoft Community Forum.

Power BI is trying to apply a Replace Value transformation on a column that no longer exists or has been renamed/removed in the data source.

Root cause: When the Replaced Value step was created, the column Business Team existed. Since then, the column was renamed, deleted, or not present in the updated Excel file. The Power Query step that tries to reference Business Team now fails.

Please follow below steps to fix the issue:

1. Go to Power Query Editor: In Power BI, click on Transform Data to open the Power Query Editor.

2. Locate the broken step: In the APPLIED STEPS panel (right side), click on the step labeled Replaced Value that has the error.

You will see the formula bar shows something like:

Table.ReplaceValue(#"Filtered Rows7","PDS Asia Star ","PDS Asia Star",Replacer.ReplaceText,{"Business Team"})

3. Check if 'Business Team' exists: Click on the previous step (Filtered Rows7) and look at the column names. If 'Business Team' is missing, this is the root cause.

4. Please try Fix options:

If the column was renamed: Use the correct column name in the Replaced Value step. If the column was removed from Excel: Re-add it to the source file if it’s needed. If not needed anymore: Delete or disable the Replaced Value step.

5. To edit the step manually:

Click on the gear icon next to Replaced Value, or right-click and select Edit Settings. Change the column name to a valid one or remove the step entirely.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @shaik1 ,

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya]

Hi @shaik1 ,

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you

[v-dineshya · Accepted solution]

Hi @shaik1 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thank you.