Forum Discussion
Getting Data via FetchXML from Dynamics
Hi Lisi ,
Based on this document——How to handle Special Characters in Fetch XML | Microsoft Dynamics 365 CRM Tips and Tricks . Fetch XML is the easiest way to write complex queries to retrieve data by joining multiple entities.
We could use webutility.htmlencode(uiname) to handle such an error. For example:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous - the following "Fetch XML is the easiest way to write complex queries to retrieve data by joining multiple entities" may be true, but Power BI would prefer a Star Schema rather than One Big Table.
Lisi - I wondering do you need to separate the URL and Relative Path to get the FetchXML to work. Chris describe this in the Blog - Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code Chris Webb's BI Blog (crossjoin.co.uk)