Connect a Time Series Database (TSDB) instance to Quick BI to query, visualize, and analyze your time-series data without leaving the BI console.
Prerequisites
Before you begin, make sure you have:
A TSDB instance.
The public endpoint and port number of your TSDB instance.
An AccessKey ID and AccessKey Secret with access to the TSDB instance.
(If your TSDB instance has a whitelist configured) The CIDR blocks of Quick BI that are used in different network environments added to the whitelist. Without this, Quick BI cannot reach your instance. See Configure a whitelist for the Quick BI CIDR blocks and configuration steps.
Add the data source
Log in to the Quick BI console.
Perform the steps to navigate to the data source management page and create a new data source. The Add TSDB Database dialog box appears.
Configure the following parameters:
Parameter Description Name Display name for this data source. Accepts letters, digits, underscores ( _), and hyphens (-).T-SQL Address\Port Number Public endpoint and port of your TSDB instance. AccessKey ID The AccessKey ID used to authenticate with the TSDB instance. AccessKey Secret The AccessKey Secret paired with the AccessKey ID above. Click Test Connection to verify connectivity.
Click OK.
The new data source appears in the data source list.
What's next
With the data source connected, you can start building analyses in Quick BI:
Create datasets from TSDB tables or custom SQL statements. See Create and manage datasets.
Build dashboards and charts to visualize your data. See Create a dashboard and Overview of charts.
Add drill-down, filter interaction, and hyperlinks for in-depth analysis. See Drilling, filter interaction, and hyperlink.