The 'Tags' column does not exist in the rowset.

Question

Hi!&nbsp;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.netActivity ID: 4f9718ed-0d5b-4eda-ac68-6790fad90687Request ID: 2f23686a-dd97-05c6-8c75-31e994d94a45Time: 2020-03-05 12: 17: 50Z

greg_deckler · Answer

That will be a tough one to troubelshoot.&nbsp;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

anonymous · Answer

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).

v-lid-msft · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
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,
&nbsp;

anonymous · Answer

The last successful refresh was at&nbsp;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".&nbsp;&nbsp;

anonymous · Answer

I'm having a similar problem with the same error message.&nbsp; My dataset uses a dataflow pointed at a SQL Server database.&nbsp; This has worked without issues for a couple of months.&nbsp; Either over the weekend or Monday, I began seeing refresh errors with this message.&nbsp; At the same time, I had a measure that quit working properly and began reporting maximum values for the field type (2+ million).&nbsp; I "fixed" the measure by ignoring it and instead re-exposing the underlying value for the measure.&nbsp; I republished from Desktop without any problems.&nbsp; Then on the first scheduled refresh on Power BI service, the 'Tags' column error reappeared.&nbsp; I'm about to try to repubish the report/dataset, but I have zero confidence that it will resolve the problem.&nbsp;

Forum Discussion

The 'Tags' column does not exist in the rowset.

5 Replies

Related content

Remove HTML tags from columns

The column does not exist in the rowset

The column does not exist in the rowset

ERROR REFRESH The '<oii>Column</oii>' column does not exist in the rowset. TablE

Tagging columns