BiitOps PowerBI Repository

Welcome to the BiitOps repository for ready to use PowerBI reports.
Here you will find a set of .pbix files which can be used with your BiitOps API datasource.
 
These report are available for free. BiitOps does not directly support these.
You may modify the visuals and datatables as you please.
 
When you download a report it comes preconfigured with a BiitOps sample dataset.

Available PowerBI Reports

PowerBi Report  Version  Module  Report Type(s)  Report Template  Sample  Download 
Active Directory Users and Computers  2.8  Active Directory Domain 64bit  Analytics  PowerBI Users and Computers Status  View Sample  Pbix file 
Failover Cluster  1.6  Failover Clustering  Analytics
Changes 		 PowerBI - All Data  View Sample  Pbix file 
Local Admins  2.2  Local Administrator Group Members  Analytics  PowerBI All Data  View Sample  Pbix file 
Certificate Overview  1.6  StandardServer (64-bit)  Analytics  PowerBI Certificate Overview  View Sample  Pbix file 
Devices and Drivers  1.5  StandardServer (64-bit)  Analytics
Changes 		 PowerBI Hardware Drivers  View Sample  Pbix file 
Interactive CMDB  1.2  Analytics Basic Modules  Inventory  PowerBI Interactive CMDB  View Sample  N/A 
Last Logon  3.1  StandardServer (64-bit)  Analytics  PowerBI Last Logon  View Sample  Pbix file 
Service Accounts  2.2  StandardServer (64-bit)  Analytics  PowerBI Service Accounts  View Sample  Pbix file 
Service Inventory  4.0  Windows Basic Information
Windows Services 		 Inventory  PowerBI - Basic Server Version Info
PowerBI - Service Inventory 		 View Sample  Pbix file 
Software Assets  1.3  StandardServer (64-bit)  Analytics
Changes 		 PowerBI Software Inventory  View Sample  Pbix file 
Windows Updates  1.1  StandardServer (64-bit)  Analytics
Changes 		 PowerBI Windows Updates  View Sample  Pbix file 
Windows Server Compliance  1.0  StandardServer (64-bit)  Analytics  N/A  View Sample  N/A 

How to setup

To use these reports, follow these simple steps.
 

Configuring the BiitOps Rest API Report

  1. Take note of the required template, listed on this page next to the PowerBI report you have selected. You will need to know the name of the Data Collection Module and the Report Template, as well as the type of BiitOps report(s), you need to configure.
  2. Log into your BiitOps Portal and goto the Templates tab. Verify the required template is available in the list, if it is not listed, select the - New Reports - tick, find the template and download it using the green arrow.
  3. Assuming the Data Collection Module has already been configured, go to the Reporting Tab, and click the + Add New option in the top left corner.
  4. On the 1st Tab, specify the name of the report, select the report type, like Analytics report and select the required template from the list. Click Next.
  5. On the 2nd tab, specify your selection logic to include the servers or service instances you would like to see in your PowerBI report. Click Next.
  6. On the 3rd Tab simply click next, as you do not need static Excel files for PowerBI reporting.
  7. On the 4th Tab select API, and then simply click the report URL. IT will get copied to your clipboard. Make a note of this URL. Click - Update.
  8. If your PowerBI report requires a second report type, create this specifying te different report type on the 1st Tab, and using the same selectionlogic on the 2nd Tab. Again make a note of the report URL.
  9. Once your click - Update - The report will generate in the background. Deplnding on the size og the data set this can take anywhere from seconds to minuttes. Once a report is generated, you will see a timestamp in the last generated column.
  10. As a last step you will have to prepare the URL for the Report Metadata. You will need both a Report URL and a Metadata URL per API Report. This is done by slightly modifying the Report URL, adding a /Metadata before the ?api_key, like this

    Report URL : https://[FQDN]/api/report/[Report Guid]?api_key=[APIKey GUID]

    Metadata URL : https://[FQDN]/api/report/[Report Guid]/Metadata?api_key=[APIKey GUID]

Configuring the PowerBI Report

  1. Download the report you would like and unzip the pbix file
  2. Within your PowerBI portal, click the lower left corner to import new data, and select the item - Files. Then select - Local File - and point to the extracted .pbix file.
  3. Once imported, you can open the report and view the sample BiitOps data.
  4. Close the report and go to the tab Dataset. Open setting on the related data set, and expand parameters. Depending on the chosen report you will have to opportunity to specify between 1 and 4 URLs, as well as a Uploaded to PowerBI Services Boolean.
  5. Insert the Report and Metadata URLs for the Report(s) and click apply.
  6. Wait a few minutes, the Credential Information will inform you that you need to configure these. Depending on your PowerBI setup, do one of the following
    1. If PowerBi has direct access to your BiitOps API URL, click each Report URL under credentials and specify anonymous.
    2. If you are using a PowerBI data gateway, configure this instead of URL level credentials. To permit the API URL access through the data gateway, simply specify the base URL of a report, like https://[FQDN]/ - without the rest of the report URL.
  7. After the credentials has been configured, go back to the Dataset Tab and click - Update Dateset - on the relevant data set.
  8. Once the Dataset update has completed successfully, you can choose the schedule automatic updates for the Dataset. 
  9. Go to the Report Tab and open your report. If the data is not available yet, click the Refresh Option with the report.

 

Feedback and ideas for new PowerBI report can be sent to - powerbi (at) BiitOps.com.