Hi, we use a SQL database to store our Canvas Data. From that i have created a number of views. Then i connect the Power BI to these views. Below is an example of a report front page   

Hi,    We use Power BI to visualise our canvas data. Id be happy to share some of my experience

Hi,   At Belfast Metropolitan College we use the Canvas Data Viewer to download the data and import it into a SQ:L Server. We then use Power BI to visualise the data

@reynlds no problem. We have moved on since I put up this post

@Travis_Carter Hi Travis, is the below what you are looking for. This tells us how many of each item were created over the lifetime that we have had Canvas    

@Travis_Carter Hi Travis, is the below what you are looking for. This tells us how many of each item were created over the lifetime that we have had Canvas    

@Doug9 Hi Doug, that would be great. Many thanksNigel

@FelixHaeuptle Hi Felix, yes it is an azure based database. I downloaded the schema from here https://api-gateway.instructure.com/doc/?_gl=1*lx1szq*_ga*ODgzOTQwMzQzLjE2NjQ1NDU2NjQ.*_ga_75H5134F9J*MTY4...

@FelixHaeuptle Hi felix, thank you for sharing these scripts. I am having an issue with the create database file.DECLARE @JSON VARCHAR(MAX)SELECT @JSON = BulkColumnFROM OPENROWSET(BULK 'C:\Users\NHump...

@Edina_Tipter do you have the current .json schema file or know where i can download it from?