- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maggie,
Thank you so much. You are my hero.
Will

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-20-2024 09:01 AM | |||
11-02-2023 08:03 AM | |||
12-13-2023 11:38 AM | |||
02-20-2024 12:24 PM | |||
12-08-2023 02:21 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |