
#CALL REST API FROM EXCEL FOR MAC 2018 WINDOWS#
Many of these connectors use native Windows libraries (for example Microsoft Access connector) and may be extremely hard to make cross platform. Power Query provides a large set of connectors to external data sources.The Data Access layer uses COM based OLEDB as the means to move data between Power Query and Excel.The UI framework is based on WinForms, Internet Explorer, and COM interop.
The Power Query codebase is written in C# and targets. Making this cross platform came with a set of challenges: The following depicts the different areas of work in this project and their relationships: In this article I will share with you our journey from a Windows only to a cross platform product: NET Core 2.1 was released it became a perfect opportunity for us to add Mac support for Power Query. NET Framework, Power Query has been traditionally a Windows only feature of Excel and has been one of the top requests by our Mac community. However, as part of Excel 2016 it was natively integrated into Excel. Originally Power Query was distributed as an Excel 2013 Add-In. The Power Query product has been in development for many years, it has a considerably large codebase, and is being used by millions of existing customers. Power Query was developed for windows and is written in C# targeting. Features in Power Query are available in Excel and Power BI Desktop.
Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources to meet your analysis needs.