List of Samples

We maintain a list of samples on the DataConnectors repo on Github. Each of the links below links to a folder in the sample repository. Generally these folders include a readme, one or more .pq / .query.pq files, a project file for Visual Studio, and in some cases icons. To open these in Visual Studio, make sure you've set up the SDK properly, and run the .mproj file from the cloned or downloaded folder.

Functionality

Sample Description Link
Hello World This very simple sample shows the basic structure of a connector. Github Link
Hello World with Docs Similar to the Hello World sample, this sample shows how to add documentation to a shared function. Github Link
Navigation Tables This sample provides two examples of how to create a navigation table for your data connector using the Table.ToNavigationTable function. Github Link
Unit Testing This sample shows how you can add simple unit testing to your .query.pq file. Github Link
Relationships This sample demonstrates the declaration of table relationships that will be detected by Power BI Desktop. Github Link

OAuth

Sample Description Link
Github This sample corresponds to the Github connector tutorial. Github Link
MyGraph This sample corresponds to the Microsoft Graph connector tutorial. Github Link

ODBC

Sample Description Link
SQL This connector sample serves as a template for ODBC connectors. Github Link
Redshift This connector sample uses the Redshift ODBC driver, and is based on the connector template. Github Link
Hive LLAP This connector sample uses the Hive ODBC driver, and is based on the connector template. Github Link
Snowflake This connector sample uses the Snowflake ODBC driver, and is based on the connector template. Github Link
Impala This connector sample uses the Cloudera Impala ODBC driver, and is based on the connector template. Github Link
Direct Query for SQL This sample creates an ODBC based custom connector that enables Direct Query for SQL Server. Github Link

TripPin

Sample Description Link
Part 1 This sample corresponds to TripPin Tutorial Part 1 - OData. Github Link
Part 2 This sample corresponds to TripPin Tutorial Part 2 - REST. Github Link
Part 3 This sample corresponds to TripPin Tutorial Part 3 - Navigation Tables. Github Link
Part 4 This sample corresponds to TripPin Tutorial Part 4 - Data Source Paths. Github Link
Part 5 This sample corresponds to TripPin Tutorial Part 5 - Paging. Github Link
Part 6 This sample corresponds to TripPin Tutorial Part 6 - Enforcing Schema. Github Link
Part 7 This sample corresponds to TripPin Tutorial Part 7 - Advanced Schema with M Types. Github Link
Part 8 This sample corresponds to TripPin Tutorial Part 8 - Adding Diagnostics. Github Link
Part 9 This sample corresponds to TripPin Tutorial Part 9 - Test Connection. Github Link
Part 10 This sample corresponds to TripPin Tutorial Part 10 - Query Folding Part 1. Github Link