Skip to main content

Posts

Showing posts with the label Power BI

Veeam API with Python as PowerBi Data Source

  Veeam API   with Python as PowerBi Data Source Power BI is a powerful business intelligence tool that allows users to visualize data and gain insights from it. While Power BI provides built-in data connectors to various sources, including SQL Server, Oracle, Excel, and others, it also supports using custom connectors to access data from various other sources.

Veeam Backup for Office 365 as DataSet for PowerBI REST API

Using Veeam Backup for Office 365 as DataSet for PowerBI using PowerBi Query.  I did a previous post on a self-service Dashboard which is built upon Veeam’s VBO APIs here: http://www.mritsurgeon.co.za/2020/07/single-install-script-for-veeam-backup.html I wanted to see if there was a way to use GET API method to share data with PowerBi as a data source. I previously did a post on Veeam Backup & Replication using its config SQL DB as Data Source for PowerBI here:

Veeam V10 Data Re-use: Part 3 - Business Intelligence

  Veeam V10 Data Re-use (Business Intelligence) So, this is a Continuation of Blog post PART 2 of Data Re-use blog series, Part two here addressed Security Analysis with Veeam Re-Use API. Business intelligence  What is Business intelligence? As Per Wikipedia: According to Forrester Research, business intelligence is "a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and operational insights and decision-making."

Veeam V10 Data Re-use: Part 1- Data Classification

Veeam V10 Data Re-use (Data Classification) So, with all this time in lockdown I’m testing use cases for the Veeam Data Re-use API. From the Graphic above you can see the general use topics of the Feature, so I decided to test use cases for each. There are 4 posts to this series, this post will focus on Data classification. Data Classification 

Using Veeam As a DataSet for PowerBI

Veeam with Microsoft PowerBI Creating a backup Statistics & analytics Dashboard with PowerBI With some time at home during lock down I decided to play round with PowerBi & learn. The easiest start for me was to plug this into a SQL database, looking around for a Data Set I thought what not easier than use the Veeam Config Database in my lab as its already holding rich data that I could transform into a Dashboard. I also have an deep knowledge into backup and can understand how & why to transform the Data Set. This was my first Time using PowerBi so bear with me .. First, I downloaded and installed PowerBI Desktop to my Veeam Backup Server (seemed easiest as data set was local to the Tool)