![]() ![]() It's also a best practice to filter out any data that isn't relevant for your case. Some connectors will take advantage of your filters through query folding, as described in Power Query query folding. ![]() It's always recommended to filter your data in the early stages of your query or as early as possible. To see the full list of available connectors in Power Query, go to Connectors in Power Query. ![]() You can even select multiple datasets from your data source through the Navigator window, as shown in the following image. In this stage, you're provided with a user-friendly window to select the data that you want to get from your data source, if the connector allows it, and a simple data preview of that data. This standardized experience has a stage called Data Preview. To read more about query folding, go to Power Query query folding.Įach data connector follows a standard experience as explained in Getting data. For example, using the SQL Server connector instead of the ODBC connector when connecting to a SQL Server database not only provides you with a much better Get Data experience, but the SQL Server connector also offers you features that can improve your experience and performance, such as query folding. Using the best connector for the task will provide you with the best experience and performance. If you don't see your data source listed in the Get Data window, you can always use the ODBC or OLEDB connector to connect to your data source. These connectors range from data sources such as TXT, CSV, and Excel files, to databases such as Microsoft SQL Server, and popular SaaS services such as Microsoft Dynamics 365 and Salesforce. Power Query offers a vast number of data connectors. This article contains some tips and tricks to make the most out of your data wrangling experience in Power Query. ![]()
0 Comments
Leave a Reply. |