Forum Discussion
Error when trying to refresh a dataset
Hi, Anonymous
According to your sample picture, it seems that you faced the problem that the xxx column does not exist in the rowset. Here are two possible reasons for this error.
The first is that the xxx column has been deleted in the original data source so that the Power BI can’t find it anymore. Another is that you have applied some table transformation operations in the Power Query like “Piovit columns” or “Unpiovit columns”, which makes the data model changes. This will also cause this kind of problem.
Here’s a blog that explains this problem in detail and gives some solutions, you can take a look:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
According to your sample picture, it seems that you faced the problem that the xxx column does not exist in the rowset. Here are two possible reasons for this error.
The first is that the xxx column has been deleted in the original data source so that the Power BI can’t find it anymore. Another is that you have applied some table transformation operations in the Power Query like “Piovit columns” or “Unpiovit columns”, which makes the data model changes. This will also cause this kind of problem.
Here’s a blog that explains this problem in detail and gives some solutions, you can take a look:
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.