Getting Data via FetchXML from Dynamics

HI Lisi - I would like understand why the standard D365 in Power BI cannot be used?  Why do you need to use the FetchXML?

Hi Daryl, if I get the data the usual way I have to import all kinds of tables and lot's of data. FetchXML would give me the chance to import a smaller amount of data from more than one entity. It would be more like importing a view from sql Server. Or is there another way? Thanks, Lisi

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.