

In addition to allowing anyone, including 3rd parties outside of Microsoft, to build connectors with this SDK, Microsoft also provides a Connector Certification program so that ISVs owning Data Platforms and Services can submit connectors built against those data sources to Microsoft for certification, enabling them to be released out-of-the-box in Power Query product experiences within Power BI (Power BI Desktop, Dataflows, and Datamarts). These connectors can be easily distributed to users, loaded into Power BI Desktop (for authoring of reports) and the On-premises data gateway (for operationalization of those reports). Today, Power BI offers one of the richest Data Connectivity platforms in the industry, powered by Power Query, with out-of-the-box connectivity to over 170 types of data sources and hundreds more through generic connectivity interfaces, enabling several millions of users to connect to data of any shape and size, and reshape it to fit their needs.Ī key contributing factor to the richness of Power Query’s Data Connectivity is that, in addition to data connectors built by Microsoft, Power Query provides an extensible platform that allows any Developer to build and release their own Power Query connectors by leveraging the Power Query Connectors SDK.
