Refresh fail in PowerBI

pang22 

Best way to fix this type issues is to download the file from the power bi service and refresh it in your desktop. Then you will be able to find which transformation step is causing the problem.

Hi all , 

tharunkumarRTK , thanks for your concern about this case, I have some additions for problem solving.

pang22 , thank you for giving a specific description of the problem. Based on your description, I will give you the following steps to solve the problem.

1.Check if your Power BI queries or reports are updated. If a column has been renamed or removed in the source data but your Power BI queries or reports haven’t been updated, the change will not be reflected in Power BI.

2.Check your data source credentials and ensure that the connection is properly configured. If there's an issue with the connection, Power BI might not be able to access the column in question.

3.Check the steps in Power Query Editor. Pay particular attention to steps that involve renaming columns, filtering rows, or removing columns. Please ensure that none of the transformations inadvertently remove or rename the column in question.

4.Check if the version of your Power BI Desktop is latest. Sometimes, the version will affect the refresh.

In addition, please review the following links which has the similar problem with yours, hope they can help you resolve the problem.

Refresh error: The xxxx column does not exist in t... - Microsoft Fabric Community

Solved: The column does not exist in the rowset - Microsoft Fabric Community

Solved: The 'HasUniqueRoleAssignments' column does not exi... - Microsoft Fabric Community

Best Regards,

Caroline Mei

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