



Power Query enables connectivity to a wide range of data sources, including data of all sizes and shapes.Įxperiences for data connectivity are too fragmentedĬonsistency of experience, and parity of query capabilities over all data sources.ĭata often needs to be reshaped before consumption Existing challengeįinding and connecting to data is too difficult Several challenges contribute to this situation, and Power Query helps address many of them. How Power Query helps with data acquisitionīusiness users spend up to 80 percent of their time on data preparation, which delays the work of analysis and decision-making. Diagram with symbolized data sources on the right, passing though Power query for transformation, and then going to various destinations, such as Azure Data Lake Storage, Dataverse, Microsoft Excel, or Power BI.
