Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
rakeshg1
Regular Visitor

"OData__ColorTag" Field not found Error

We have dataflows set up from our SharePoint List. Today we see a new error saying "OData__ColorTag" field not found. When we tried to remove this field using "Remove Columns" It says field does not exist. Not sure how to fix this. Any one experienced this issue before?

 

PowerBI Refresh Error.jpg

1 ACCEPTED SOLUTION
aggregator3000
Advocate II
Advocate II

Hi guys, happy to confirm I have found a workaround. Seems like we need to move over to new API versions

 

You can achieve via recreating/amending your dataset via either of the following:

UI

New Data -> SharePoint Online Lists -> Implementation 2.0 -> View Mode Default

Then either substitute in that M code to your original sheet / fully recreate on the new datasource

 

M Code

 

let
    Source = 
        SharePoint.Tables(  "https://[Org].sharepoint.com/sites/[Site URL]/", 
                            [   Implementation="2.0", 
                                ViewMode="Default"
                                ]
                            )
in
    Source

/*
Old source code for reference only
Source = SharePoint.Tables(
    "https://[Org].sharepoint.com/sites/[Site URL]/",
    [ApiVersion = 15]
  )
*/

 

 

Note: To expand/retrieve some foreign data in one of the subtables (user email address), now I have to extrapolate to rows first, and then values.. this is because there is a 1:N potential for the people/group data type

 

@SaurabhiS @rakeshg1 @Chielles 

View solution in original post

9 REPLIES 9
Tudor4it
New Member

Hi!

 

This error is still persisting on my reports consuming data from SP lists.

 

When it will be fixed? Where are the Microsoft people to give an insight?

Thank you!

@Tudor4it 

The older PQ-SP Connector / API version doesn't support some new SharePoint List feature

Confirmed fix can be found below

https://community.powerbi.com/t5/Service/quot-OData-ColorTag-quot-Field-not-found-Error/m-p/3194670/... 

rakeshg1
Regular Visitor

UPDATE:
Thank you all for your responses. The OData_ColorTag error is gone this morning. But now getting good old 429 too many requests error.

Hi @rakeshg1 

You can refer to the following link.

Solved: Error 29 TOO MANY REQUESTS - Microsoft Power BI Community

Solved: 429 TOO MANY REQUESTS dataflow - Microsoft Power BI Community

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SaurabhiS
Frequent Visitor

@aggregator3000  thank you this solution worked.

 

But while implementing the solution I found out that OData_ColorTag is now visible in list similar to Odata_UIVersion column and if Table.RemoveColumns  is used, we can add the OData_ColorTag column in there or if Table.SelectColumns is used no change is required. 

aggregator3000
Advocate II
Advocate II

Hi guys, happy to confirm I have found a workaround. Seems like we need to move over to new API versions

 

You can achieve via recreating/amending your dataset via either of the following:

UI

New Data -> SharePoint Online Lists -> Implementation 2.0 -> View Mode Default

Then either substitute in that M code to your original sheet / fully recreate on the new datasource

 

M Code

 

let
    Source = 
        SharePoint.Tables(  "https://[Org].sharepoint.com/sites/[Site URL]/", 
                            [   Implementation="2.0", 
                                ViewMode="Default"
                                ]
                            )
in
    Source

/*
Old source code for reference only
Source = SharePoint.Tables(
    "https://[Org].sharepoint.com/sites/[Site URL]/",
    [ApiVersion = 15]
  )
*/

 

 

Note: To expand/retrieve some foreign data in one of the subtables (user email address), now I have to extrapolate to rows first, and then values.. this is because there is a 1:N potential for the people/group data type

 

@SaurabhiS @rakeshg1 @Chielles 

SaurabhiS
Frequent Visitor

Agreed I had same issue, the issue is that the "OData_ColorTag" column in a Table disappears after being visible for a few minutes, which is causing difficulty in implementing the Table.RemoveColumns step. Even using the Table.SelectColumns step results in an error. I tried writing query after data is loaded which worked for the first two refreshes but then failed. The formula was "if (List.Contains(PreviousStepName[ColumnNames], "OData__ColorGroup")) then Table.RemoveColumns(PreviousStepName, {"OData__ColorGroup"}) else PreviousStepName".

aggregator3000
Advocate II
Advocate II

Same issue today also. Syd Australia.

This is a system column within a Sharepoint List data source. For us, it appears in the initial PQ Data load when using SP List as a data source.
No changes have occurred to the source asset, no changes to any source data records.


We were referencing explicitly it in a 'Remove Columns' (Table.RemoveColumns) PowerQuery step.
Updated PQ script to do the reverse, via 'Choose Columns' (Table.SelectColumns) step, as this will implicitly remove any columns outside of the defined list. Therefore it's not part of the M code, not part of the end-data load.

Result: Still doesn't work

 

Edit 1

Further working through the PQ steps, I can see one expanded value from the UserInfoItem is throwing that error. Even though we are not wanting to expand this specific colourtag column.

In the source dataset, the data type is 'Person or Group'

 

Edit 2

Now we cannot even load the list with zero PQ alterations

aggregator3000_0-1681864445679.png

Edit 3

Similar topics have occurred and used the first fix I tried. This does not work for us, with the error seeming to exist within a table that we have to expand

(2017 - Role Assignments does not appear in the rowset) 

Chielles
New Member

Same issue as of today

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.