In the previous post we extracted and stored the retrieved json files in a Sharepoint document library. The creation of a Power BI dataset on top of the extracted Power BI Admin API json files is described here. This includes the extract, transform and load process as well as the creation of the relationship between the different tables and the creation of DAX measures. In the end possible visualization techniques are presented.