Refresh failure in PowerBI

[pang22]

Dears,

I refresh the PowerBI 2 times a day. Sometimes it may cause error with below message "column does not exit".

But I have this column in my dataset. Do you know the reason why it refreshes failure?

[Ritaf1983 · Accepted solution]

Hi @pang22 

This error might be caused when a column was removed or renamed in the original data source.

Check your data for the above conditions. Then try to clear Power BI Desktop cache and click the refresh button to check if the error still exists.

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

[Anonymous · Accepted solution]

Hi @pang22 ,
Thanks to @Ritaf1983  for the solution. 
I found some methods on the forum you can try to troubleshoot your problem.
Solved: The column does not exist in the rowset - Microsoft Fabric Community
Solved: The 'HasUniqueRoleAssignments' column does not exi... - Microsoft Fabric Community

Best regards,

Albert He

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

[Ritaf1983 · Accepted solution]

Hi @pang22 

This error might be caused when a column was removed or renamed in the original data source.

Check your data for the above conditions. Then try to clear Power BI Desktop cache and click the refresh button to check if the error still exists.

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