[Feature Request] View "Power Query"

[mores]

Given this fetch xml:

<fetch> <entity name="opportunity" > <attribute name="name" /> <link-entity name="account" from="accountid" to="parentaccountid" > <attribute name="name" /> </link-entity> </entity> </fetch>

Output: PowerQuery.txt

This will allow me to paste it in "Advanced Editor" of the PowerBI Power Query Editor

[rappen]

Thanks for the idea! I don't know basically anything of Power Query... Who want to help this implement this?

[mores]

There is another tool in the toolbox: https://crmchartguy.com/power-query-builder/ https://github.com/ITLec/PowerQueryBuilder that does convert the fetchXML into PowerQuery but it just feels clunky jumping from tool to tool and would be better if this functionality was in FetchXMLBuilder

[UlrikBC]

The Power Query Builder does have the FetchXML Builder integration. i.e. you can open PQB, click the button to use FXB, create your query and return to PQB and finish the setup. There's a decent amount of logic in PQB that determines how the fields are expanded depending on their type to get the right label.