How to execute the Microsoft SQL table-valued function in Bold BI

Bold BI allows you to execute the table-valued function using the Microsoft SQL data source code view by following these steps.

Creating a table-valued function in the Microsoft SQL server

Create a table-valued function in the Microsoft SQL Server before connecting the data source in Bold BI.

Sample query:

  CREATE FUNCTION tableValuedReleases (
    @ReleaseId INT
    )
    RETURNS TABLE
    AS
    RETURN
    SELECT
    ReleaseId,
    ReleaseDate,
    ReleaseVersion,
    LastModifiedDate,
    IsActive
    FROM
    Releases
    WHERE
    ReleaseId = @ReleaseId;

Executing the table-valued function in Bold BI

1. Refer to the Connecting Bold BI to SQL data source to successfully connect to it.

2. After connecting to the data source, switch to the code view by enabling the slider option in the tools pane in the data design view, and you can find the query editor window in which you can execute the custom queries as follows.

   

3. Here, you can enter the query to fetch the data from the tableValuedReleases table-valued function by passing the value for the ReleaseId parameter. After entering the query, click on the Run button to execute the query.

   

4. You can view the data for your query at the bottom of the query editor by clicking Update.