Getting error in while refreshing the dashboard

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