Power BI

In this guide, you’ll learn to integrate Power BI with vScope using the API to automate data extraction and visualization.

---

Prerequisites

Before starting, ensure you have an API Token for secure access to vScope. Follow this guide for token setup: Fetching data via API.

Also, make sure Power BI is installed on your computer:
Download Power BI

---

Create a Source Table in vScope

1. Open Table Explorer and create a new table by selecting All Machines as the resource.

2. Add Columns: Add columns such as IP and CPU Usage to customize your data.

3. Add Filters: For example, filter machines with Running = true.

4. Save Table: Name your table (e.g., Source Table for Power BI).

   

5. Locate TableID: After saving, go to Collaborators and find the Permalink ID for the table (the unique identifier at the end of the link).

Note

This ID can also be found by going into your browser’s console and entering: vscope.dumpPreset().

---

Get the Data into Power BI

Power BI allows data imports from various sources, including API endpoints. You’ll use the vScope endpoint for XLSX export to pull the table directly into Power BI.

1. Find Endpoint: Use this format to create the endpoint URL:

GET https://{YOUR-VSCOPE}/rest/v1/tables/{YOUR-TABLEID}/data/xlsx

Replace {YOUR-TABLEID} with the ID from vScope and {YOUR-VSCOPE} with your server address.

2. Power BI Setup:

• Open Power BI.
• Go to Home > Get Data and select Web.

3. Configure API in Power BI:

• Under the Advanced tab, enter your endpoint URL.
• Add Token: In the HTTP header parameters, set the key to token and paste your API token from vScope.

4. Preview and Load: After hitting OK, Power BI will show a preview of the data. Click Load to import it into Power BI.

---

Visualize the Data

You can now use Power BI’s features to create charts, reports, and dashboards with your imported data. The table you created in vScope serves as a dynamic data source—any updates in vScope (like new columns or filters) will reflect in Power BI upon refresh.

1. Add Columns: Add new columns or filters to the vScope table.
2. Save and Refresh: Save your table changes in vScope, then click Refresh in Power BI to sync data updates.

---

Tips

• Multiple Tables: Repeat this process to create and visualize multiple tables within Power BI.
• Automation Potential: This setup supports automation across reporting tools, making data consistently available for analysis in Power BI and other platforms.

This integration helps you take full advantage of vScope’s data for automated reporting and visualization, keeping insights available and up-to-date across your organization.