Seeing both Display name and Name as 2 different columns

[Saloman]

Hi Team,

Here is my case,

I have around 80 columns in Dataverse table when I tried to get them using Dataverse connection in Power BI I am seeing 223 columns at Power Query Editor,what I have observed here is both Dispaly Name and Name from Database are getting loaded as 2 Different columns,I only need to see Display Name for my ask,is there any way to exclude those extra columns at the source level instead of manually exclude the extra ones in PBI Query Editor.

Responses are highly Appreciated,Thanks in Advance!

[danextian]

Hi @Saloman 

I don't think it is possible to specify the Display Name straight from when creating a connection. There isn't  an option to specify such.

If Display Name or Database Name follows a distinct naming convention unique to itself, you could create a step that dynamically selects a set of columns based on specific logic.