Reply
wperkinson
Frequent Visitor

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

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

1 ACCEPTED SOLUTION
v-juanli-msft
Community Support
Community Support

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

 

View solution in original post

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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

 

Maggie,

 

Thank you so much.  You are my hero.

 

Will

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)