Connect to 1010data from Power BI

Once you install the ODBC Driver and 1010data Power BI Connector and adjust the security settings, you are ready to connect to 1010data from Power BI.

To start Power BI and connect to 1010data:

  1. Open Microsoft Power BI.
  2. Select Get Data.
    A Get Data dialog appears.

  3. Select 1010data and click Connect.
    You can also enter 1010data in the Search box to find it easily.
    A Connecting to a third-party service warning appears the first time you connect. Click Continue. A 1010data dialog appears.
  4. Enter your Data Source Name from your DSN Configuration screen.
  5. Under Data Connectivity mode, select DirectQuery in order to run queries in the 1010data Insights Platform.
    Import is generally not recommended.
    Note: For more information about the fields in this dialog, see Connection dialog.
  6. Click OK.
    A Navigator window appears, containing all the tables available to you in your 1010data environment.

    Note: Power BI uses the path and table names from the Insights Platform (not the table titles).
  7. (Optional) If you enter a Data Source Name different from the one you entered in the DSN Configuration screen during the installation process, a credential dialog appears.
    1. Enter your User name and Password for the specified Data Source Name.
    2. Click Connect.
      A Navigator window appears, containing all the tables available to you in your 1010data environment.
  8. Select your table(s) from the Navigator.
    You will see a preview of the table you selected in the preview pane.

  9. Click the check box and click Load to load the table into Power BI.
    A Create connections dialog appears while Power BI loads the data. After the data is loaded, Power BI takes you to the Report () view of the application.
You can now analyze your data and create visualizations in Power BI.