@Riser : I never tested this but i think you can do that with RESTAPI from the Meraki and get the data in JSON format
https://developer.cisco.com/meraki/mv-sense/#!rest-api/enable-api
And on other hand in PowerBi
according to the content in the link that the API Reponses in JSON, you can get the data by using "Get Data"-->"Other"-->"Web". And then extend JSON to a table in query editor.
eg. http://jsonplaceholder.typicode.com/posts/1/comments
You can replace it with a link like "http://[school].myschoolapp.com/api/academics/department/?t=[token returned from previous step]" in your link.
![1.JPG 1.JPG](https://community.meraki.com/t5/image/serverpage/image-id/17342i48A01B4D3C8F0BA1/image-size/large?v=v2&px=999)
![2.JPG 2.JPG](https://community.meraki.com/t5/image/serverpage/image-id/17343i3CF680C39694D500/image-size/large?v=v2&px=999)
![3.JPG 3.JPG](https://community.meraki.com/t5/image/serverpage/image-id/17344iB3EAB1D5AE7E5A8B/image-size/large?v=v2&px=999)
![4.JPG 4.JPG](https://community.meraki.com/t5/image/serverpage/image-id/17345iCDAF6D710FBE6D26/image-size/large?v=v2&px=999)
Regarding refreshing, you can publish it to Power BI Service and schedule refresh. Let me know if it resolves
Regards
Inderdeep Singh
Regards/Inder
Cisco IT Blogs awarded in 2020 & 2021
www.thenetworkdna.com