Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |