Creating queries on Power BI (static reports with visuals) – RightData

Users can now create different Queries using Power BI. Let’s create a Query using this reporting profile.

To learn more, let us walk through the below procedure:

Click the ‘QUERY STUDIO’ module.
Hover on the ‘Query Builder’ snippet from the left pane options.
Click the ‘Query.’

Path: QUERY STUDIO > Query Builder > Query

This action navigates the user to the ‘Query’ session page.

Select ‘POWER BI Tenant Id’ from the ‘Profile’ drop-down list.
Click the ‘Navigator’ button.

A ‘Navigator’ slide screen is displayed.
Click the ‘Sales and Marketing Sample PBIX’ report from the ‘WorkSpaces.’

This action loads the ‘Sales and Marketing Sample PBIX’ report.

Select and click ‘May-14’ from the ‘Total Units and Total Units R12Ms by Month.’

Note: The user can view and select any visual from the report and execute the required data.

This action displays ‘VisualContainer1’ toaster message.

Note: In this use case it is VisualContainer but it will change based on the user requirement.

Click the ‘Show Data’ button.

This action navigates the user to the ‘Results for VisualContainer1’ tab.

Note: DataTrust uses Microsoft Java script SDK to fetch the data from the visual container in CSV format. This API has a limitation of bringing 30,000 max records. So, this limits the end-user to retrieve maximum of 30,000 records.

Reference link for Microsoft:

The maximum number of rows that Power BI Desktop and Power BI service can export to a .csv file is 30,000.

Click the ‘Save Query’ button.

An ‘Additional savings option’ pop-up window is displayed.
Add ‘VisualContainer1 Query’ in the ‘Query Name’ text field.
Click the ‘Save’ button.

A toaster message ‘VisualContainer1 Query saved successfully!’ is displayed.
Now, click the ‘QUERY STUDIO’ module.

This action navigates the user to the ‘Query Explorer’ session page.
Search ‘VisualContainer1’ from the ‘Search’ text field.
The user can view the Query (VisualContainer1 Query).