Error when trying to refresh a dataset

[Anonymous]

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

[starsoul]

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

[v-robertq-msft · Accepted solution]

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:

https://community.powerbi.com/t5/Community-Blog/Refresh-error-The-xxxx-column-does-not-exist-in-the-rowset/ba-p/1832793

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.

[parry2k]

@Anonymous so in the service it is connected to the same data source?

[parry2k]

@Anonymous does it refresh fine in Power BI Desktop?

[Anonymous]

Yes, no issues.