Can you specify the columns to reference when creating a new data query?

[wperkinson]

I am trying to establish a connection to our Dynamics 365 online service.(CRM)

My goal is to connect to the salesorders, but when trying to build the connection it errors with the message "We don't support duplicate properties in the feed."

We have a customization whereby a user can "Clone" an existing order.  When the new order is created, there is a relationship between it and the original record.  When I try to import into Power BI, it sees it as a circular reference and will not let me pull the data.

There is one column "new_clone_source_order" that is causing the problem.  Is there a way to specify in the advanced editor to not include this column?

Thank you,

Will

[v-juanli-msft · Accepted solution]

Hi @wperkinson

 Is there a way to specify in the advanced editor to not include this column?

Please use this code in edit queries->advanced editor

let

   source=your table,

   new table=Table.RemoveColumns(source,"new_clone_source_order")

in

   new table

Best Regards

maggie

[wperkinson]

Maggie,

Thank you so much.  You are my hero.

Will