Cisco API & Azure

[Cotadwaree]

Hello, I'll use Cisco API as data source. How can i make a connection from Cisco API to populate data in power BI?

I might be using an sql Database to extract data from Cisco API and then send data to power BI.

CAN WE OR  use AZURE to extract data from Cisco API, store the data in Azure and then send the data directly to power BI?

My email add is rajiv.dwaree@dimensiondata.com

[v-qiuyu-msft · Accepted solution]

Hi @Cotadwaree,

Power BI can get data from SQL Server database, Azure SQL database or Azure SQL Data Warehouse.

In your scenario, you need to import data to Azure SQL database or Azure SQL Data Warehouse firstly. You can take a look at links below:

Load data into Azure SQL Data Warehouse

Loading data to SQL Azure the fast way

Also if possible, you can call REST API in desktop directly. See this sample: How to call REST APIs and parse JSON with Power BI.

Best Regards,
Qiuyun Yu

[Cotadwaree]

Hello,

To call REST API in desktop directly would help a lot. For instance you mean that i would be able to Connect A Cisco API directly with the Deskptop BI without having a data store or sql server?

Right?

[v-qiuyu-msft]

Hi @Cotadwaree,

Yes, it's possible. We can call rest API in desktop, you can check the sample in my previous post.

Best Regards,
Qiuyun Yu