It is, technically, possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how to run a UPDATE statement to update data in a table in SQL Server.
Have you ever tried putting something in the clipboard? Well, aside from literally copying or pasting?
If you have ever tried something like this in .NET, you might remember, you need to call the functionality in a thread with STA mode. Try doing this in your NAV Development Environment…
Automation lets you use the capabilities and features of Microsoft Office products, such as Microsoft Word or Microsoft Excel, in your Microsoft Dynamics NAV application. Today we will implement Word Automation from a customer card in the Microsoft Dynamics NAV Windows client. Note: The Microsoft Dynamics NAV Web client does not support automation
XML documents can be created/processed via xmlports. An other opportunity is the usage of Codeunit 6224. It’s used for complex XML handling. This CU only delivers some create and find functions, but no read/get functions. Following functions extend CU 6224 with read functions.