Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How to retrieve the following data to generate the PowerBI report real-time in 10 second from the api link with post method (http: //daviddung.com:3006/xdapi/Solieugiaoban) with the json string variable:
{
"Value": {
"IDLoaiVP": {
"xq": 33,
"sa": 36,
"sat": 75,
"ct": 63,
"mri": 47,
"dsa": 51,
"ecg":35,
"lx":32,
"ns":34
},
"ListMaKP": "",
"ListCDCS": "2",
"Ngay": "14/04/2017"
},
"Key": "6MVB2P/hb7AzsTw7npN1jJ02BcIrR4a8kZpTCm4XeaBUjPxzkka+JAY58Spb0LveE6Z1EbdwZZ5b3H++AMRQHn"
}
IDLoaiVP, ListMaKP, ListCDCS, Right variables: will be changed to get dynamic data.
The returned json data is as follows:
{
"Value": [
{
"MaKP": "039",
"TenKP": "NTH1",
"Khambenh": 100,
"Benhcu": 0,
"Nhapvien": 0,
"CSCI": 0,
"Chuyenkhoa": 0,
"Chuyenvien": 0,
"Tuvong": 0,
"Xuatvien": 0,
"Hienco": 0,
"SLVP": {
"xq": 0,
"sa": 26,
"sat": 0,
"ct": 0,
"mri": 0,
"dsa": 0,
"ecg": 3,
"lx": 0,
"ns": 22
}
},
{
"MaKP": "121",
"TenKP": "NT3",
"Khambenh": 28,
"Benhcu": 0,
"Nhapvien": 0,
"CSCI": 0,
"Chuyenkhoa": 0,
"Chuyenvien": 0,
"Tuvong": 0,
"Xuatvien": 0,
"Hienco": 0,
"SLVP": null
}
],
"ErrorMessage": null
}
For real time purpose, you can check Real-time streaming in Power BI.
As to how to feed the dataset with your data from your api, you'll have to build the bridge, maybe by using a C# console app calling the post API every 10 seconds and keep pushing data to Power BI.
Hi @Eric_Zhang
I have a C # console app that calls API logging every 10 seconds to push data into the dataset in power bi but error: The operation has time out
If I turn off the application and reboot then it works for a short time, then the error again.
How to fix
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |