Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |