BitSight Security Ratings
If you’re a business owner, you already know the importance of cybersecurity. One of the ways to ensure the safety of your business is by using tools that can help you monitor your security ratings. BitSight is an excellent platform that allows you to do just that. In this article, we will explore the Power Query M Language code for connecting to the BitSight Security Ratings data source from inside Power BI.
What is Power Query M Language?
Power Query is a data transformation and cleansing tool that allows you to extract, transform, and load data from various sources. Power Query M language is the language used by Power Query to perform these data transformations. With Power Query M language, you can write custom data transformations that are not available in the Power Query user interface.
What is BitSight Security Ratings?
BitSight Security Ratings is a platform that allows you to monitor your security ratings. BitSight’s rating system provides an objective, evidence-based look at your organization’s security performance, giving you the information you need to make informed decisions about your security posture.
Connecting to the BitSight Security Ratings Data Source from Inside Power BI
To connect to the BitSight Security Ratings data source from inside Power BI, we need to use the Power Query Editor. The Power Query Editor is a feature within Power BI that allows you to connect to various data sources and perform transformations on the data.
Here’s how you can connect to the BitSight Security Ratings data source from inside Power BI:
1. Open Power BI Desktop and select “Get Data” from the Home tab.
2. In the “Get Data” window, type “Web” in the search bar, and then select “Web” from the results.
3. In the “From Web” dialog box, type the URL for the BitSight Security Ratings data source. The URL is “https://api.bitsighttech.com/ratings/v1/security-ratings”.
4. Click “OK” to connect to the data source.
5. In the “Navigator” window, select the table you want to use, and then click “Edit.”
Once you click “Edit,” the Power Query Editor will open, and you can start transforming the data.
Implementing the Power Query M Language Code
To implement the Power Query M Language code, follow these steps:
1. Open the Power Query Editor.
2. In the “Home” tab, click “Advanced Editor.”
3. In the “Advanced Editor” window, copy and paste the following code:
let
Source = Json.Document(Web.Contents(“https://api.bitsighttech.com/ratings/v1/security-ratings”)),
#”Converted to Table” = Record.ToTable(Source),
#”Expanded Value” = Table.ExpandListColumn(#”Converted to Table”, “Value”),
#”Expanded Value1″ = Table.ExpandRecordColumn(#”Expanded Value”, “Value”, {“name”, “rating”, “industryVertical”, “bitSightId”}, {“name”, “rating”, “industryVertical”, “bitSightId”}),
#”Renamed Columns” = Table.RenameColumns(#”Expanded Value1″,{{“name”, “Company Name”}, {“rating”, “Security Rating”}, {“industryVertical”, “Industry Vertical”}, {“bitSightId”, “BitSight ID”}})
in
#”Renamed Columns”
4. Click “Done.”
The above code will create a table with the following columns:
– Company Name
– Security Rating
– Industry Vertical
– BitSight ID
The table will contain information about the BitSight Security Ratings for your organization.
Conclusion
Connecting to the BitSight Security Ratings data source from inside Power BI is a straightforward process. By using the Power Query M Language code, you can create custom transformations that will help you monitor your security ratings. With this information, you can make informed decisions about your organization’s security posture and protect your business from cybersecurity threats.
