Monthly Organizational Reports API/Google Sheet

Getting noticed

Monthly Organizational Reports API/Google Sheet

Hi, devs,

Looking for an API to assist in pulling my monthly organizational reports. I need to link the reports to PowerBi for clear visualization. Any ideas will be appreciated.

Kind of a big deal
Kind of a big deal

@Riser : I never tested this but i think you can do that with RESTAPI from the Meraki and get the data in JSON format!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.



You can replace it with a link like "http://[school][token returned from previous step]" in your link.


Regarding refreshing, you can publish it to Power BI Service and schedule refresh. Let me know if it resolves 


Inderdeep Singh


Cisco IT Blogs awarded in 2020 & 2021

That is cool @Inderdeep !

Get notified when there are additional replies to this discussion.
Welcome to the Meraki Community!
To start contributing, simply sign in with your Cisco account. If you don't yet have a Cisco account, you can sign up.