Forum Discussion
Error when trying to refresh a dataset
Hi Experts
I cannot see the wood for the trees - i.e. where the error could be...
See image of Error when trying to refresh Dataset Power Bi Serveices
see image of data model
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.
5 Replies
Anonymous does it refresh fine in Power BI Desktop?
Anonymous so in the service it is connected to the same data source?
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.
Even I am facing the same issue. Getting below error message without the name of the table. I have around 100 table in the model and most of them have a description field as a column. Now don't know how to find which table is causing this issue. Everything works fine in Power BI Desktop app. Last time when I encountered this problem, I started deleting tables 1 by 1 I figured out which table is causing service to fail. Then I refreshed that column manually and published it again and it got fixed. But now again am getting this issue. I can't delete tables every time it's very time consuming. Cant you share the Table name which this column doesn't exist. Database used in the back is MYSQL.
Data source error: The 'DESCRIPTION' column does not exist in the rowset.
Cluster URI: WABI-INDIA-WEST-redirect.analysis.windows.net
Activity ID: xxxxxxx
Request ID: xxxxxxx
Time: 2021-08-21 11:07:35Z
