Forum Discussion

Cotadwaree's avatar
Cotadwaree
Regular Visitor
9 years ago
Solved

Cisco API & Azure

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 da...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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's avatar
    Cotadwaree
    Regular Visitor
    9 years ago

    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's avatar
      v-qiuyu-msft
      Community Support
      9 years ago

      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