![]() ![]() Once you create a query with Power Query, you can use the Query Editor tool to transform the data to better meet your needs. And the benefits of Power Query do not stop there. This means that end-users - even those with minimal query skills - are able to use Power Query to link data from virtually any external data source into Excel. ![]() In fact, Power Query currently supports querying data from 40 different sources, including other Excel files common databases such as Access, SQL Server, SAP Hana, IBM DB2, Oracle and MySQL text files webpages Facebook Salesforce Objects and Salesforce Reports and even Open Database Connectivity, which is a generic standard for accessing data from virtually all modern databases. Power Query provides tools to assist in querying data from external data sources. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |