Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I'm using a dataflow connected to some excel files on sharepoint and recently I'm geting this error on power bi service dataset refresh. On desktop works fine.
I don't have any reference to this column.
Data source error: The 'Tags' column does not exist in the rowset. Table: DataSourcesCurves.
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 4f9718ed-0d5b-4eda-ac68-6790fad90687
Request ID: 2f23686a-dd97-05c6-8c75-31e994d94a45
Time: 2020-03-05 12: 17: 50Z
That will be a tough one to troubelshoot. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I already seen the other "The 'xyz' column does not exist in the rowset. " posts, none resolve my case where I never refer to the column and start to get wrong alone (there's no alteration on files or m scripts).
Hi @Alessandro82 ,
What is the last time your dataflow can refresh successfully? Could you please try to verify if you can see this column in a new dataflow using the same query? Are there any changes applied to this 'Tags' column in the origin file recently?
Best regards,
I'm having a similar problem with the same error message. My dataset uses a dataflow pointed at a SQL Server database. This has worked without issues for a couple of months. Either over the weekend or Monday, I began seeing refresh errors with this message. At the same time, I had a measure that quit working properly and began reporting maximum values for the field type (2+ million). I "fixed" the measure by ignoring it and instead re-exposing the underlying value for the measure. I republished from Desktop without any problems. Then on the first scheduled refresh on Power BI service, the 'Tags' column error reappeared. I'm about to try to repubish the report/dataset, but I have zero confidence that it will resolve the problem.
The last successful refresh was at 3/3/2020, 9:25:06 AM.
After that, we update power bi desktop to v. fev/20, and include a connection to a sharepoint list getting a list of AD Users.
But on the table that having the error nothing was changed, and also we doesn't even querying the column "Tags".
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.