NET on all platforms, with minimal platform specific code.Īny effort to port to. Our long term goal is to have a single cross platform codebase, running on the same. NET Framework 3.5 build side by side to the. This basically means we need to maintain the existing. Whatever we do, do not break our existing Windows users :).We set for ourselves two major requirements: The refresh project requires minimal user interface and would lay the groundwork needed for the rest of the project. This blog will focus on the refresh scenario leaving the authoring (UI) parts for future posts. Authoring: Port the authoring UI to Mac.This covers a large use case, as it allows data analysts to create workbooks once, and have Mac users consume these workbooks and refresh the data as it updates. Refresh only: Use Windows to author Excel workbooks with Power Query queries inside them, and then allow our Mac users to refresh these workbooks using Excel for Mac.Thus, we made a project management decision to split the project into two major sub projects: It is quite obvious this turned out to be quite an undertaking and would require multiple man years to get done. For RPC it depends on Remoting, and some WCF features which are not natively supported by. The build and testing infrastructure were developed to run on Windows machines.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |