Install the connector

Watch the video, or follow the instructions below to install the Power BI Connector.

To install the connector:

  1. Contact your account representative to enable SQL connection features on your account.
  2. Ensure Power BI is installed and is up to date.
  3. Find the Windows ODBC package and the Power BI Connector at this link.
  4. Download both the ODBC executable and the Power BI Connector file.
    Both files are now in your downloads directory.

  5. Run the ODBC Driver Setup wizard.
    The ODBC Driver for 1010data Setup screen appears.

  6. Follow the prompts in the ODBC Driver Setup wizard to install and configure the ODBC Driver.
  7. When you get to the Installation completed successfully dialog, make sure Configure ODBC Data Source is selected and click Finish.
    The DSN Configuration screen appears.
  8. In the DSN Configuration screen, enter the following information:
    1. Data Source Name: Name your connection (you will need to remember this for later). A DSN is the name that applications use to request a connection to a data source.
      You can also use the default data source name (DSN): CData C1010 Source.
    2. User: Enter your user name.
    3. Password: Enter your password.
    4. Login URL: Enter the URL of the 1010data environment you are accessing, including the version (such as /prime-16.40) as shown. The Power BI connector is compatible with the 1010data Insights Platform V15 and above.
      Note: Any version of the 1010data Insights Platform after V15 will work. However, as a best practice, we recommend using prime-latest as the version.
  9. Click Test Connection.
    You should see the following dialog:

  10. Click OK in this dialog and click OK again to exit the DSN Configuration screen.
    Note: If you need to make further changes to your DSN Configuration screen in the future, run the program ConfigureODBC in the directory C:\Program Files\Cdata\CData ODBC Driver for 1010data.
  11. Move the .pqx file you downloaded to the folder C:\Users\[USERNAME]\Documents\Power BI Desktop\Custom Connectors.
You can now connect to Power BI using the instructions in Connect to 1010data from Power BI.