Query execution using Power BI (paginated reports)

The query is a part of the QUERY STUDIO module. Using Query, users can execute single or multiple SQL Queries by selecting the desired data source profile. Let’s execute the Query using ‘Power BI’ using paginated reports.

Let us walk through the below procedure:

• Click the ‘QUERY STUDIO’ module.

• Hover on the left pane options to view the ‘Query Builder’ snippet.
• Click the ‘Query’ option.

Note: The user can click the ‘Query’ from the left pane options. Also, he/she can directly click the ‘New Query’ button or ‘New Query’ text from the drop-down list.

Path 01: QUERY STUDIO > Query Builder > Query

Path 02: QUERY STUDIO > New Query

• The user is navigated to the ‘Query Builder’ session page.

• Let’s select ‘Power BI using Tenant Id’ from the ‘Profile’ drop-down list.
• Click the ‘Navigator’ from the right side of the page.

• Let’s select and click the ‘Sales Performance’ from the ‘Reports.’

• This action loads the ‘Sales Performance’ report.

• Select ‘True’ radio button option for ‘Expand Salesperson’ option.
• Click the ‘View report’ button.

• This action loads the ‘Sales Performance’ visualization report.
• Let’s click the ‘Paginated Report Parameters.’

• This action displays a ‘Properties’ slide screen.
• Under the ‘Paginated Report Filters’, let’s add ‘ExpandSalesperson’ as ‘Key’ and ‘TRUE’ as ‘Value.’

Note: The 'Key' parameter name must be the same as the Key parameter name taken from the Power BI cloud server.

• Click the ‘Apply’ button.

• This action navigates the user to the ‘Sales Performance’ visualization report.
• Click the ‘Show Data Without Filters’ option.

Note: By default, the 'Show Data Without Filters' selects the CSV download option. The user can also select CSV or Excel from the 'Show Data Without Filters' drop-down list depending on the requirement.

• The CSV download enables the ‘Skip Rows’ option.

Note: Skip rows specifies the number of initial rows to skip before loading the data. The ‘Skip rows’ number is different for each reporting sheet.

• Now, click the ‘Excel’ download option.

• The Excel download enables the ‘Data range’ (Ex: #A2:E4) option.

Note: The user has to give the ‘Data range’ value while selecting the excel download option.

• Select the ‘CSV’ option again.

• This enables the ‘Skip rows’ option.
• Add the ‘Skip rows’ value as ‘3’ here.
• Click the ‘Show Data Without Filters’ icon.

• This action navigates the user to the ‘Results for’ tab displaying the execution results.