AvePoint Docs
Graph API
My support tickets
Graph API
My support tickets
English

    Home > User Guide > Integrate with Tableau and Power BI > Create a Data Service

    Export to PDF

    Create a Data Service

    To integrate with Tableau and Power BI, complete the following steps to create and run a data service:

    1. Click Data service in the left navigation.

    2. On the Data service page, click New service. The Create a data service panel appears.

    3. Configure the following settings:

      • Data service name – Enter a name for the new data service.

      • Organization – Select an organization from the drop-down list.

      • Description – Enter an optional description for the data service.

      • Endpoint types – Both SQL and OData are selected and supported for the connection to Tableau and Power BI.

      • Data scope – Click Add, then select the objects and specify the fields to be included in the data service. You can click Preview to preview your selection. To remove a field, click the Remove button next to it.

      • Up to 10 objects can be added. To edit an object, select the object in the Create a data service panel, and click Edit. To remove objects, select the objects and click Remove.

      • First snapshot for backup data – Click the field to select and apply a date to fetch the first snapshot. After saving and running the data service, the first snapshot will be fetched at the designated date, including backup data from the latest full backup job until that date.

      • If the selected date is later than the current date, no data will be fetched in the job started when you save the data service. If you enable the Extend fetch schedule option, the next job will run on the designated date.

      • Snapshot fetching interval – Set an interval to fetch snapshots. After the fetch of the first snapshot, snapshots will be fetched at the designated intervals until the job running date. Each snapshot will include backup data from the latest full backup job until it was fetched.

      • Extend fetch schedule – Once enabled, snapshots will continue to be fetched at the designated intervals after the last job completed date of the data service, ensuring ongoing updates.

      • Database – Select a database from the drop-down list. You can also click Add new database in the drop-down list to add a new database.

    4. Click Save & Run. The new service will display on the Data service page, and a data service job will start to fetch snapshots.

    After the data service job has started, you can go to the job monitor to track the progress. After the job is finished, you can click the Job ID link to view the general information. For details, refer to Job Monitor.

    Note that data service jobs that include records exceeding SQL Server length limit (8,060 bytes) will finish with an exception, and the backup data for the corresponding objects cannot be imported into Power BI or Tableau.

    To run a data service job on demand, click the More commands button on the upper right corner of the data service tile on the **Data** **service** page, and then select **Run now**. You can run one on-demand job per month by default. To update a data service after the creation, click the More commands button on the upper right corner of the data service tile on the **Data** **service** page, and then select **Configure data service**. If you enable **Extend fetch schedule**, the data service job will start to fetch snapshots when you save the updates. If you add/update objects in **Data scope**, update **First snapshot for backup data**, **Snapshot fetching interval**, or **Database**, all existing data will be deleted, and a new job will run based on the updates. To delete the data service, click the More commands button on the upper right corner of the data service tile on the **Data** **service** page, and then select **Delete service**.