Forum Discussion
Error Adding Dataverse tables from the Default Environment into Power BI Desktop
When I try and add a Dataverse table from my default environment I get the following error
Expression.Error: The field 'new_itemclassname' already exists in the record.
Details:
Name=new_itemclassname
Value=
This happens on loading any table in the default environment whether they are built in or custom. Power BI Desktop does not allow the table to load. This happens on a brand new blank report.
The problem does not exist if I load dataverse tables from other environments
Has anyone see this and have suggestions on how to troubleshoot?
The error means there's a duplicate column name (new_itemclassname) in the Dataverse table schema—likely caused by hidden metadata or relationships in the Default Environment. Power BI can't load it because each field must be unique. Try using a custom view, switching to OData, or loading from a different environment to bypass the issue
4 Replies
PaulineSP Is the only step the Source/Navigation steps? If not, try removing steps until the error goes away and then investigate that step or post what it is doing here.
It literally appears on the initial load when selecting the table - before any steps can be added
The error means there's a duplicate column name (new_itemclassname) in the Dataverse table schema—likely caused by hidden metadata or relationships in the Default Environment. Power BI can't load it because each field must be unique. Try using a custom view, switching to OData, or loading from a different environment to bypass the issue
Thanks so much Shahid12523. I will probably go down the route of creating a new environment but just wondered what you meant by try using a custom view? Thanks
