cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gghneim Frequent Visitor
Frequent Visitor

Expression.Error: The field 'displayName' already exists in the record.

Hi All,

 

I had been experimenting with using an OData connection to "https://graph.microsoft.com/beta/users" the last few weeks as a good way to pull in live organizational user data. This had been working like a charm for a few weeks. But the last few days, any time I tried to refresh the data I would get the following error:

 

Expression.Error: The field 'displayName' already exists in the record.
Details:
Name=displayName
Value=

 

I thought maybe I had renamed a column something I shouldn't have but I couldn't find anything. I finally just tried to create a new connection in a different report and it wouldn't even load the data and would return the same error. I'm at a bit of a loss. Anyone ever see this before?

 

Thanks!

6 REPLIES 6
Community Support Team
Community Support Team

Re: Expression.Error: The field 'displayName' already exists in the record.

Hi @gghneim,

 

Please check the "Applied steps" in query editor to find which step caused this error.

 

When you tried to create a new connection, please clear the cache (File->Options and settings->Options->Data Load) and test again.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gghneim Frequent Visitor
Frequent Visitor

Re: Expression.Error: The field 'displayName' already exists in the record.

Thank you for the reply @v-yulgu-msft.

 

I removed all the applied steps before. It is occuring on the initial load. I cleared the cache as you advised but still no luck. I'm starting to wonder if the Microsoft Graph feed is the problem.

kevincoetzee Frequent Visitor
Frequent Visitor

Re: Expression.Error: The field 'displayName' already exists in the record.

I'm having exactly the same issue - any resolution to this yet? It does seem like there is an issue with Microsoft Graph

nsc
Advisor

Re: Expression.Error: The field 'displayName' already exists in the record.

Same issue here, worked fine a few weeks ago, now initially had to use an embed token to get access and when I do that I get the same error, must be something with the graph api that's changed.

zack_attack Visitor
Visitor

Re: Expression.Error: The field 'displayName' already exists in the record.

I was having the same issue and this is how I solved it.

 

Go into your query editor and click on the query showing the error/warning icon (triangle) - usually the panel on the left of the data tables. You have to look at your applied steps (panel on the right) and find at which point your data still looked like you wanted (click on each step. Essentially, the step immediately after is responsible for throwing the error.

nsc
Advisor

Re: Expression.Error: The field 'displayName' already exists in the record.

Yes, normally that is a good approach, but in this case it's a matter of the Microsoft Graph API not working anymore for Power BI. Hopefully MS will enable support for this in the near future...