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 > More.
    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 one of the following:
    OptionDescription
    Import Power BI caches the data and creates a snapshot of your data at a certain point in time.
    DirectQuery You are querying the underlying data in real time and getting the most up to date data.
    In general, DirectQuery is the preferable method of obtaining data. If you are connecting to a 1010data magic table, you must use DirectQuery.
    Note: For more information about the fields in this dialog, see Connection dialog.
  6. Click OK.
    A Navigator window appears, containing the database tenten.

  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 the database tenten.
  8. Expand tenten in the Navigator.
    The Navigator displays the 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).
  9. Select your table(s) from the Navigator.
    You will see a preview of the table you selected in the preview pane.

  10. 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.
The next time you want to connect to the same 1010data source, select Recent sources > CData C1010 Source (or the name of the source you entered in Data Source Name).